"Private synonyms for a role?" No, synonyms can be created for: tables,
views, procedures, packages and functions, and maybe for types, and some
of the other newer objects in Oracle, but you cannot creates synonyms
for: users, roles or schemas.

-----Original Message-----
From: Sikyala Raquel
[mailto:oracledba-ezmlmshield-x26482778.[Email address protected]
Sent: Tuesday, February 27, 2007 1:42 PM
To: LazyDBA Discussion
Subject: Spam: 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



THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE AND ANY ATTACHMENTS SENT FROM GENTEX CORPORATION IS GENTEX CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE PERSONAL USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. If you are not the intended recipient, you are hereby notified that any review, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail, and delete this e-mail message and any attachments from your computer.



Oracle LazyDBA home page