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

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...