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

 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications Oracle Database - How to check if user roles and system roles are separated?
# 1  
Old 08-21-2015
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-21-2015 at 01:59 AM.. Reason: Add CODE tags.
# 2  
Old 08-21-2015
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
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Solaris

How do you assign multiple roles in RBAC?

Oracle Solaris 10 9/10 s10s_u9wos_14a SPARC Hi, just starting with RBAC. I have managed to create a test user with assigned roles: Basic Actions Basic Solaris UserI also didroleadd -d /export/home/userrole -m userrolebut when I didrolemod -P "Basic Actions" userrole rolemod -P "Basic... (1 Reply)
Discussion started by: rino19ny
1 Replies

2. AIX

Customize Roles - HMC

Hi All, i would like to know if it's possible to create a new custom role on HMC to manage only one LPAR and few activity on it (START,STOP,CONSOLE). It's possible create this custom role? If yes where i can read something about? Thanks in advance. Bye. Zio (1 Reply)
Discussion started by: Zio Bill
1 Replies

3. Solaris

LDAP users with RBAC Roles

I have an issue with integration between Microsoft LDAP users and RBAC roles defined in a Solaris box. to explain more , i managed to integrate Microsoft Active Directory user loggings to Solaris boxes. I've done it to centralize user repo. and instead of creating admin accounts on more than... (9 Replies)
Discussion started by: mduweik
9 Replies

4. Red Hat

Roles & Responsibilities of a Linux/Unix administrator

Hi All, At present i have good knowledge and experience in unix/ linux shell scripting. I believe unix shell scripting with administration will be a hot skill set, so I would like to become a Unix/Linux system admin. What are the key skills i have to learn to become a successful administrator.... (1 Reply)
Discussion started by: apsprabhu
1 Replies

5. UNIX and Linux Applications

roles and responsibilites in unix shell scripting as a production support consultant

what are the roles and responsibilites in unix shell scripting as a production support consultant in oracle database (2 Replies)
Discussion started by: alokjyotibal
2 Replies

6. Solaris

Need help, restrict DBA roles in Sun Solaris Server

Dear forum, I have Oracle 9i/10g2R and sun solaris server I don't realy sure wheter it's sun solaris 8, 9 or 10. Here is the background: OS : SunOS 8/9/10 Oracle engine : 9i / 10g2R --> located in server SunOS Remote Komputer : Windows XP, I use SSH to remote to the server User : DBA1,... (0 Replies)
Discussion started by: Aditya Purwanto
0 Replies

7. UNIX for Dummies Questions & Answers

Monitoring Server Jobs, Roles, and Performance via Command Line

Hey guys, I have an up and coming interview (tomorrow) and during the discussion via phone I was asked if I was familiar with "monitoring jobs in Linux/UNIX using the command line." Now, I currently work in the MS world and I am underneath the NOC hear at my company so I have had no reason to do... (2 Replies)
Discussion started by: Steve M
2 Replies

8. UNIX for Advanced & Expert Users

How to find permissions/roles/priveleges of User

Hello Everyone, if we log on to unix server how do we find that what permissions/roles and priveleges are assigned to any particular user. Here i am not talking about the file permissions. Thanks (1 Reply)
Discussion started by: hardesh
1 Replies

9. UNIX for Dummies Questions & Answers

Adding MS 2000 FSMO Roles to Unix Bind

In a Windows 2000 active directory environment (using Unix DNS), is it possible to create entries in Unix Bind to point Microsoft Workstations to specific Microsoft servers, depending on their Microsoft FSMO roles (i.e. Domain Naming Master, PDC Emulator, RID, Infrastructure Master)? In other... (0 Replies)
Discussion started by: breffkin
0 Replies
Login or Register to Ask a Question

Featured Tech Videos