Skip to Main Content
Forums

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!

View grants

Mehul MehtaAug 9 2012 — edited Aug 9 2012
Hello,

How can i view grants given to DBA Role? Its because i have xe database.

Actually i have created two schemas, for example.

1) ABC , 2) XYZ

and i have created function that inserts data from ABC to xyz i have granted DBA role to ABC and XYZ both, but when i try to compile function in ABC schema it shows me an error that table or view does not exits. But i have table on xyz schema.

So just wanted to what are the privelages granted to DBA role.

Regards,

Mehul
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 6 2012
Added on Aug 9 2012
#11g, #database, #dba, #general-database-discussions
3 comments
356 views