Locking Oracle schemas
Hi,
I have a question about locking oracle schemas...what is the purpose of doing this actually?
I have some schemas in a database which are probably not being used anymore and therefore can be dropped. But before dropping them, I just wanted to lock the schemas for the time being and see if anyone reacts.
But I googled locking an oracle schema and came across an Ask Tom website where he answers the following question:
You Asked
How to disable/lock a schema temporarily so that no user can access the tables in the schema
and we said...
You do not lock schemas from access.
You grant or revoke on objects.
You would have to revoke select on the tables in this schema from whomever has access to
them. Additionally - anyone with various "ANY" privs (select ANY table - like a DBA) would not be affected.
You could also use fine grained access controls to make the tables appear "empty"
http://asktom.oracle.com/~tkyte/article2/index.html
But this will all be done at the object level, not a schema level. And even things like
fine grained access control can be gotten around by individuals with sufficient privileges.
Now I am confused - seems to me like locking the schema to prevent access to all data in the schema seems like a better option than what Tom suggests. Can anyone clarify this? Thanks.