Another Oracle blog

  • Home
  • About
  • About

Tag Archives: privileges

Home / Posts Tagged: privileges

Check which user has EXECUTE privilege on a package

SELECT grantee, privilege   FROM dba_tab_privs  WHERE owner = upper(‘&OWNER’)    AND table_name = ‘&TABLE_NAME’    AND privilege = ‘EXECUTE’;

October 23, 2015mardaffSQLprivileges

Get all the privileges of the current session

select * from session_privs;

October 23, 2015mardaffSQLprivileges
ora-base.com