Michael A. Georgiou
マイケル
Technical articles for oracle database
Search This Blog
Wednesday, December 28, 2011
Revoke object granted to PUBLIC for a specific USER
SELECT ' revoke all on '||owner||'.'||table_name||' from public;'
FROM table_privileges
WHERE grantee = 'PUBLIC'
AND OWNER='UM'
ORDER BY owner, table_name;
Newer Post
Older Post
Home