DDL of privilege of user
select 'grant ' || privilege ||' on ' || owner || '.' || table_name || ' to "' || grantee ||'"'|| decode(grantable,'YES',' WITH GRANT OPTION',null) || ';' "TXT"
from dba_tab_privs where grantee in (select username from dba_users where username in ('xxxxx'));
select 'grant ' || privilege ||' on ' || owner || '.' || table_name || ' to "' || grantee ||'"'|| decode(grantable,'YES',' WITH GRANT OPTION',null) || ';' "TXT"
from dba_tab_privs where grantee in (select username from dba_users where username in ('xxxxx'));
No comments:
Post a Comment