Hakki Al Saidi حقي الساعدي
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' ;
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)