Tuesday, 21 July 2026

1. Oracle EBS Technical: How to Check User Access and Privileges on Custom PL/SQL Packages Using DBA_TAB_PRIVS



SELECT grantee, privilege, grantor 

FROM dba_tab_privs 

WHERE table_name = 'XXCUST_EMP_PKG' 

  --AND owner = 'PACKAGE_OWNER_SCHEMA'

ORDER BY grantee;

No comments:

Post a Comment