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!

What is the version of grant alter table, drop table to user in Oracle 10g?

480011Jul 10 2006 — edited Jul 11 2006

Hi,

Oracle support "grant alter table and drop table" before, but I get the "invalid privilege" error in Oracle 10g. Oracle 10g have the "DROP ANY TABLE" and "Alter any table". Is these two means can drop and alter tables belonging to other users? How do I grant the total control (CRUD) of tables in the owner's schema to the owner in Oracle10g?

Thanks,
Jiang

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 8 2006

Added on Jul 10 2006

#general-database-discussions

4 comments

2,829 views