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


Closed    
 
Thread Tools Search this Thread Display Modes
    #1  
Old Unix and Linux 08-20-2015
alvinoo alvinoo is offline
Registered User
 
Join Date: Jun 2015
Last Activity: 14 November 2016, 9:32 AM EST
Posts: 83
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?


Code:
SQL> desc DBA_ROLES;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ROLE                                      NOT NULL VARCHAR2(30)
 PASSWORD_REQUIRED                                  VARCHAR2(8)
 AUTHENTICATION_TYPE                                VARCHAR2(11)

SQL> desc DBA_SYS_PRIVS;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GRANTEE                                   NOT NULL VARCHAR2(30)
 PRIVILEGE                                 NOT NULL VARCHAR2(40)
 ADMIN_OPTION                                       VARCHAR2(3)


Last edited by Don Cragun; 08-20-2015 at 11:59 PM.. Reason: Add CODE tags.
Sponsored Links
    #2  
Old Unix and Linux 08-21-2015
rbatte1 rbatte1 is offline Forum Staff  
Root armed
 
Join Date: Jun 2007
Last Activity: 23 June 2017, 11:03 AM EDT
Location: Lancashire, UK
Posts: 3,141
Thanks: 1,316
Thanked 600 Times in 542 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.




Robin
Sponsored Links
Closed

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 07:12 AM
LDAP users with RBAC Roles mduweik Solaris 9 01-29-2010 06:32 PM
Need help, restrict DBA roles in Sun Solaris Server Aditya Purwanto Solaris 0 08-31-2006 10:10 PM
How to find permissions/roles/priveleges of User hardesh UNIX for Advanced & Expert Users 1 09-27-2005 09:22 AM



All times are GMT -4. The time now is 06:36 AM.