Unix/Linux Go Back    

UNIX and Linux Applications Discuss UNIX and Linux software applications. This includes SQL, Databases, Middleware, MOM, SOA, EDA, CEP, BI, BPM and similar topics.

Oracle Database - How to check if user roles and system roles are separated?

UNIX and Linux Applications

Thread Tools Search this Thread Display Modes
Old Unix and Linux 08-20-2015   -   Original Discussion by alvinoo
alvinoo's Unix or Linux Image
alvinoo alvinoo is offline
Registered User
Join Date: Jun 2015
Last Activity: 5 January 2018, 8:38 PM EST
Posts: 96
Thanks: 8
Thanked 1 Time in 1 Post
Oracle Database - How to check if user roles and system roles are separated?

I have these two table. How do I see if user roles and system roles are seperated?

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ROLE                                      NOT NULL VARCHAR2(30)
 PASSWORD_REQUIRED                                  VARCHAR2(8)
 AUTHENTICATION_TYPE                                VARCHAR2(11)

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GRANTEE                                   NOT NULL VARCHAR2(30)
 PRIVILEGE                                 NOT NULL VARCHAR2(40)
 ADMIN_OPTION                                       VARCHAR2(3)

Last edited by Don Cragun; 08-21-2015 at 12:59 AM.. Reason: Add CODE tags.
Sponsored Links
Old Unix and Linux 08-21-2015   -   Original Discussion by alvinoo
rbatte1's Unix or Linux Image
rbatte1 rbatte1 is offline Forum Staff  
Root armed
Join Date: Jun 2007
Last Activity: 19 January 2018, 12:39 PM EST
Location: Lancashire, UK
Posts: 3,441
Thanks: 1,493
Thanked 671 Times in 604 Posts
You need to look at table DBA_ROLE_PRIVS to see which accounts have what roles granted, however you have to then know what those roles grant, so you will have to review:-
  • DBA_ROLE_PRIVS again for nested roles
  • DBA_TAB_PRIVS for data access rights
  • DBA_SYS_PRIVS for system privileges
You may findthat you loop through DBA_ROLE_PRIVS a few times. Also remember that there is the PUBLIC role to consider.

Sponsored Links

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Customize Roles - HMC Zio Bill AIX 1 10-21-2011 08:12 AM
LDAP users with RBAC Roles mduweik Solaris 9 01-29-2010 07:32 PM
Need help, restrict DBA roles in Sun Solaris Server Aditya Purwanto Solaris 0 08-31-2006 11:10 PM
How to find permissions/roles/priveleges of User hardesh UNIX for Advanced & Expert Users 1 09-27-2005 10:22 AM

All times are GMT -4. The time now is 03:15 PM.