Connect as the user in question.

At a SQL prompt, type this:
************************************************

SQL>select * from session_privs;
PRIVLEGES
--------------------------------------
CREATE SESSION
Blah
Blah
blah

************************************************

To create the role:

Assign Privilege To A Role
--------------------------

GRANT <privilege_name> TO <role_name>;
example:
GRANT CREATE SESSION TO <role_name>;

Create A Role Heirarchy
-----------------------
example
CREATE ROLE <super_roll_name>;
GRANT <role_name> TO <super_roll_name>;



Jeffrey C. Ferrel
DMS III
State of Nevada
775.687.9327
[Email address protected]


-----Original Message-----
From: Sikyala Raquel
[mailto:oracledba-ezmlmshield-x26482778.[Email address protected]
Sent: Tuesday, February 27, 2007 10:42 AM
To: LazyDBA Discussion
Subject: Grant a users privileges to a role

I need to identify what privileges a user has and grant those privileges
to a role and create private synonym for that role as well. Could
someone please help me. Please provide the correct syntax.






---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page