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!

Grant all privileges on one schema to another schema

556496May 1 2007 — edited Jul 10 2007

Hi,
Currently I'm using 8i database and I'm having a problem in using this statement

GRANT ALL ON SCHEMA <SHEMA_NAME1> TO <SCHEMA_NAME2>

and showing me this error :

ORA-00905: missing keyword

Kindly tell me where I am doing wrong and is there anyother way to provide access of one schema tables to another schema table ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 7 2007

Added on May 1 2007

#general-database-discussions

6 comments

2,445 views