Hi all,
for audit reasons we are not allowed to grant rights to Public. Now for a few days there is always a right that is automatically granted.
SELECT * FROM dba_tab_privs WHERE grantee = 'PUBLIC' AND owner = 'XXXXXXXXXX' GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRA HIE COM TYPE INH ---------- ---------- ------------------------------ ---------- ---------------------------------------- --- --- --- ------------------------ --- PUBLIC XXXXXXXXXX ST00001VQR0xGSIqbgUwYKF6yqCA= XXXXXXXXXX EXECUTE NO NO NO TYPE NO
Is there a way to find the procdure or package which causes the grant?
If I revoke the right, it will be granted again in the following days with another "Table" Name
thanks for your help
regards
Rudi
