Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

An Oracle DBA question

 
Jane Somerfield
Ranch Hand
Posts: 193
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm using Oracle 10g.

I logged into the DB as "sysdba" using sqlplus and created a role "MY_ROLE":

SQL> create role MY_ROLE;

I granted some privileges on MY_TABLE to MY_ROLE as below:

SQL> grant select, insert, update, delete on MY_TABLE to MY_ROLE;

I can see MY_ROLE with

SQL> select name from user$ where type#=0 and name like 'MY_%';

My question is in which Oracle table where I can review the
MY_ROLE's privileges that I granted.
 
Scott Selikoff
author
Saloon Keeper
Posts: 4014
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't know the exact table name, but you should either search google for "Oracle meta data tables" or just use a graphical viewer to see the full list of system tables in the database. I believe the user tables start with "user_"
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic