Register / Login
Win a copy of
Mesos in Action
this week in the
JDBC and Relational Databases
An Oracle DBA question
posted 9 years ago
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.
posted 8 years ago
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_"
[OCA 8 Book]
[OCP 8 Book]
* SCJP (1.4, 1.6) * OCAJP 8 * OCPJP 8
is that a bug with PreparedStatement ?
compare a long datatype to a string in select statement
Oracle JDBC Thin Client behaviour concerning date data types and it's format.