Thursday, July 7, 2011

Create Script To Revoke User Privileges

SELECT distinct 'revoke ' || privilege || ' on ' || grantor||'.'|| table_name||' from USERNAME;'
FROM DBA_TAB_PRIVS
WHERE grantor = 'SCHIMA_NAME'
And table_name Like '%CDR%VOICE%'
AND grantee like 'USERNAME' ;