Skip to Main Content

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!

drop a table that belongs to another schema

user128148Oct 19 2007 — edited Oct 19 2007
Hello,

Which system privilege can I grant to drop a table that belongs to another schema?
UserA has the 'drop table' privilege. But this only allows UserA to drop its own table. Which privilege would allow UserA to drop UserB's table? I do not want to give UserA the 'drop any table'. Thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 16 2007
Added on Oct 19 2007
1 comment
1,249 views