Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g user rights management study notes     - How wifi-linux AP signal strength detection (Linux)

- CentOS 7 How to connect to a wireless network (Linux)

- MySQL Tutorial: Building MySQL Cluster under Linux (Database)

- Linux system last command usage (Linux)

- Linux System Getting Started Learning: hard disk partition, and to deal with traps (Linux)

- Not safe procedure under Linux (Linux)

- Analysis of MySQL High Availability (Database)

- Linux process scheduling opportunity (Programming)

- Apple Mac computer to install Windows 10 Concise Guide (Linux)

- Oracle 11gr2 new APPEND_VALUES tips (Database)

- Oracle JDK installation under Ubuntu Linux (Linux)

- Use FFmpeg processing high quality GIF (Programming)

- Java study notes: String (Programming)

- Linux Log File Browser --logrotate (Linux)

- C ++ constant definition (Programming)

- Ubuntu 14.04 / Linux Mint 17 How to install the MintMenu 5.5.2 menu (Linux)

- CentOS install SVN server configuration and automatically synchronized to the Web directory (Server)

- Java programmers talk about those advanced knowledge and direction (Programming)

- It is time to upgrade your gulp 4.0 (Programming)

- To install OwnCloud 7.0.4 under Ubuntu (Linux)

 
         
  Oracle 11g user rights management study notes
     
  Add Date : 2018-11-21      
         
         
         
  Summing up the work often use some Oracle 11g user rights management study notes:

1 View all database users each have a role:
select * from (select distinct connect_by_root grantee username, granted_role
from dba_role_privs
connect by prior granted_role = grantee) a
where exists (select 1 from dba_users b where b.username = a.username)
order by 1,2
;

2, view the database system privileges for all users:
select d.username, d.privilege from
(Select a.username, b.privilege from
(Select distinct connect_by_root grantee username, granted_role
from dba_role_privs
connect by prior granted_role = grantee) a,
(Select grantee, privilege from dba_sys_privs) b
where a.granted_role = b.grantee
union
select grantee, privilege from dba_sys_privs) d
where exists ((select 1 from dba_users c where d.username = c.username))
order by 1,2;

3, view the database table permissions for all users
select d.username, d.privilege, d.owner, d.table_name from
(Select a.username, b.privilege, b.owner, b.table_name from
(Select distinct connect_by_root grantee username, granted_role
from dba_role_privs
connect by prior granted_role = grantee) a,
(Select grantee, owner, table_name, privilege from dba_tab_privs) b
where a.granted_role = b.grantee
union
select grantee, privilege, owner, table_name from dba_tab_privs) d
where exists ((select 1 from dba_users c where d.username = c.username))
order by 1,2;

4, how to view the user has the DBA role?
Conventional practice is generally directly query DBA_ROLE_PRIVS view. Query as follows:
select grantee, granted_role from dba_role_privs where granted_role = 'DBA';
This user will miss the test as follows:

Correct query statement queries shall be as follows:
select * from (select distinct connect_by_root grantee username, granted_role
from dba_role_privs
connect by prior granted_role = grantee) a
where a.granted_role = 'DBA';

5, view the user has the SELECT ANY TABLE privilege
For grant role, look at who has the authority to query all the tables
select distinct rp.grantee from dba_role_privs rp, dba_sys_privs sp
where rp.granted_role = sp.grantee
and sp.privilege like 'SELECT ANY TABLE%'
     
         
         
         
  More:      
 
- MySQL Statistics (Database)
- SecureCRT session buffer size settings (Linux)
- VMware Workstation virtual machine cloning (Linux)
- Oracle Database Performance Optimization of memory disk (Database)
- How to use Xmanager Remote Desktop and VNC Log (Linux)
- MySQL5.7 JSON type using presentation (Database)
- grub boot error resolution examples (Linux)
- Reported too many open files Linux solutions (Server)
- JavaScript event handling Detailed (Programming)
- Common data structures and functions of Linux process scheduling (Programming)
- Kubuntu 14.04 desktop to the user how to upgrade KDE 4.13.2 (Linux)
- Four safety delete files under Linux tools (Linux)
- Ubuntu Gnome and Fedora 22 Gnome desktop, extended to achieve global menu (Linux)
- Linux system font color change (Linux)
- Debian 8 (amd64) installation deployment Memcached management tools MemAdmin (Server)
- CentOS 6.6 install Oracle 11gR2 database (Database)
- CentOS install expect (Linux)
- Linux scheduling summary (Linux)
- Error code: 2013 Lost connection to MySQL server during query (Database)
- Linux Getting Started tutorial: How to backup Linux systems (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.