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
‹
›
Home
View web version
No comments:
Post a Comment