Friday, February 24, 2017

Find all privileges a user

SQL>conn sys as sysdba
SQL> grant all privileges  to LIMA;

Grant succeeded.

SQL> select count(*),grantee             ------------------------------see all privileges
  2       from dba_sys_privs
  3       where grantee in ('MDSYS','LIMA','SYS')
  4       group by grantee;

  COUNT(*) GRANTEE
---------- ------------------------------
        19 MDSYS
       200 LIMA
       200 SYS
SQL>conn LIMA/lima@orcl
SQL> create user kaium identified by kaium;

User Created

No comments:

Post a Comment

 https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/