Improve company productivity with a Business Account.Sign Up

x
?
Solved

Oracle - View roles assigned to my username

Posted on 2013-06-13
6
Medium Priority
?
449 Views
Last Modified: 2013-06-13
In oracle is there a way to see what roles/permissions are assigned to my username?
0
Comment
Question by:patriotpacer
  • 3
  • 2
6 Comments
 
LVL 79

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 39244422
There are a few views you can check:

http://docs.oracle.com/cd/E11882_01/server.112/e25513/toc.htm

USER_ROLE_PRIVS
USER_ROLE_PRIVS describes the roles granted to the current user.

USER_SYS_PRIVS
USER_SYS_PRIVS describes system privileges granted to the current user.

USER_TAB_PRIVS
USER_TAB_PRIVS describes the object grants for which the current user is the object owner, grantor, or grantee. Its columns are the same as those in DBA_TAB_PRIVS.
0
 

Author Closing Comment

by:patriotpacer
ID: 39244433
Thx (again) slightwv!
0
 
LVL 50

Expert Comment

by:PortletPaul
ID: 39244468
try these:
SELECT * FROM USER_SYS_PRIVS;
SELECT * FROM USER_TAB_PRIVS;
SELECT * FROM USER_ROLE_PRIVS;
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
LVL 50

Expert Comment

by:PortletPaul
ID: 39244470
:0 oops no refresh - too late (again) sorry
0
 
LVL 79

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39244472
Way late this time Paul!!!  ;)
0
 
LVL 50

Expert Comment

by:PortletPaul
ID: 39244492
yes, had to put a cat to bed :)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
An introductory discussion about Oracle Analytic Functions which are used to calculate or compute Aggregate values, based on a group of rows.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to recover a database from a user managed backup

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question