Why alter user lock, still can query?-CodePudding

I am using Oracle database 21c Express edition in Windows x64. With system user, I run

alter user `bichvan` account lock

With system user

but, in Oracle SQL Developer, session of user bichvan, I still can query.

Why alter user lock, still can query?

CodePudding user response：

Documentation says:

To temporarily deny access to the database for a particular user account, you can lock the user account. If the user then attempts to connect, then the database displays an error message and does not allow the connection.

It means that lock won't affect currently logged users. But, if you disconnect and then try to connect, you won't be allowed to do that.