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!

Grant all to a table in another objects schema

157689May 7 2003 — edited May 8 2003

Hi,

I want to create a table in another users schema (this works) and then grant rights to other users or roles on that table, which is not in my schema.

When issuing the statement:
GRANT ALL ON OTHER_USER.TABLE_NAME TO ROLE_OR_USER
I get the error ORA-01929: no privileges to GRANT

Which privilege do I need to do this? Is it only possible for the DBA?

I'm running Oracle 8.1.7 on Sun Solaris.

Thanks for your help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 5 2003

Added on May 7 2003

7 comments

1,192 views