How to check grants on database objects in oracle

SELECT * FROM ALL_TAB_PRIVS
WHERE TABLE_NAME LIKE ‘TABLE_OR_PACKAGE_OR_PROCEDURE_OR_FUNCTION’;

Advertisements