A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
An Oracle DBA question
Joined: Jul 20, 2002
Jun 27, 2007 19:45:00
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.
Joined: Oct 23, 2005
Jul 03, 2007 08:06:00
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_"
Down Home Country Coding with Scott Selikoff
rocket mass heater
subject: An Oracle DBA question
Oracle JDBC Thin Client behaviour concerning date data types and it's format.
is that a bug with PreparedStatement ?
compare a long datatype to a string in select statement
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014