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!

Renaming a schema name and full priveleges

YES Bank DBA teamAug 26 2010 — edited Aug 26 2010

Hi,

1) it possible to rename a particular schema in oracle 9i.For example the existing schema name is xyz,i want it to be renamed to abc.I dont want to do it using exp/imp.Any help will be appreciated

2)Secondly is it possible to give full rights on one schema to another schema by giving single command or any alternative.

For example

Schema A should full rights on Schema B objects (i.e insert,delete,execute,create etc)

regards
Vijay

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 23 2010

Added on Aug 26 2010

#general-database-discussions

10 comments

1,040 views