Grants...

I understand.. whatever happening in my schema is wrong..

I have granted two roles.. CONNECT and RESOURCE

So I would like to know which privileges SCOTT has received through these two ROLES

Quote:

---

Originally posted by Sameer
Which DD will give me list of privileges given to ROLE
CONNECT and RESOURCE?

Sameer

---

Code:

---

SQL> /* I'm connected as sys/pwd as sysdba  */
SQL> select privilege, admin_option
  2  from dba_sys_privs
  3  where grantee='CONNECT';

PRIVILEGE                                ADM
---------------------------------------- ---
ALTER SESSION                            NO
CREATE CLUSTER                          NO
CREATE DATABASE LINK                    NO
CREATE SEQUENCE                          NO
CREATE SESSION                          NO
CREATE SYNONYM                          NO
CREATE TABLE                            NO
CREATE VIEW                              NO

8 rows selected.

---

I am giving up... :-((

CONNECT:

PRIVILEGE ADMIN_OPTION
---------------------------------------- ------------
ALTER SESSION NO
CREATE CLUSTER NO
CREATE DATABASE LINK NO
CREATE SEQUENCE NO
CREATE SESSION NO
CREATE SYNONYM NO
CREATE TABLE NO
CREATE VIEW NO

RESOURCE:

PRIVILEGE ADMIN_OPTION
---------------------------------------- ------------
CREATE CLUSTER NO
CREATE INDEXTYPE NO
CREATE OPERATOR NO
CREATE PROCEDURE NO
CREATE SEQUENCE NO
CREATE TABLE NO
CREATE TRIGGER NO
CREATE TYPE NO


Something weird is happening in my case ..

Anyway Thanks a lot.. I know it should work properly as it is working in u r case and in Jeff's case.. Should work in my case also.. May be my its time to go home! :-)

Thanks

Sameer

drop scott, recreate him and then see.
Do it tomorrow, i'm too getting out of my office..;)

Thats the only option..

sometime simple things are difficult to understand

ciao

Sameer