Skip to Main Content
Forums

Database Software

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!

User Locked But can access from Other users

Vineeth.KPJul 3 2015 — edited Jul 3 2015

Hi All,

I Locked an User in oracle, And when trying to login "Account is Locked" message is displaying.

But im able to query tables of this user from other users. How to block this?

For Example:

I had blocked an user named USER1. When i logged in to an User called USER2 and when i call SELECT * FROM USER1.TABLE_NAME, data is displaying.

I need to block this querying from other USERS.

Please Help

Thanks in Advance..
This post has been answered by Vlad Visan-Oracle on Jul 3 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 31 2015
Added on Jul 3 2015
#database-security, #database-security-general
5 comments
2,224 views