SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Block the access to a schema temporarily

User_F2HJQFeb 20 2013 — edited Feb 20 2013

Hi Experts,

11gR2 DB.

We have schema say X. The account is currently locked.

Is there a way to lock all the access to that schema by others also?

Means, for the time being it should be like - the schema is not existing for other users except the system users like SYS, SYSTEM...

I know to do it by revoking all the privileges, but it looks clumsy..

Sorry, if the question is too silly..

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 20 2013

Added on Feb 20 2013

5 comments

253 views