Oracle Database Discussions

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!

Restrict insert, update, delete other user's table

KartikDabaJan 27 2016 — edited Jan 28 2016

I have created a new database user. I granted following system privileges in TOAD.

select any table
alter any table
drop any table

I found that account can select, alter, drop table of other schema's tables. So how can I restrict the that account to alter, drop only its owned tables and select all schema's table?

This post has been answered by KartikDaba on Jan 27 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 25 2016

Added on Jan 27 2016

#general-database-discussions

11 comments

3,371 views