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' ;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment