Difference between revisions of "Recreate objects using dbms metadata.get ddl"
From dbawiki
(Created page with "===Recreate all the users(including grants) in a database=== select dbms_metadata.get_ddl('USER', username) || '/' ddl from dba_users union all select dbms_metadata.get_grant...") |
|||
| Line 1: | Line 1: | ||
| − | ===Recreate all the users(including grants) in a database=== | + | ===Recreate all the users (including grants) in a database=== |
select dbms_metadata.get_ddl('USER', username) || '/' ddl | select dbms_metadata.get_ddl('USER', username) || '/' ddl | ||
from dba_users | from dba_users | ||
Latest revision as of 20:06, 8 December 2011
Recreate all the users (including grants) in a database[edit]
select dbms_metadata.get_ddl('USER', username) || '/' ddl
from dba_users
union all
select dbms_metadata.get_granted_ddl('ROLE_GRANT', username) || '/' ddl
from dba_users
union all
select dbms_metadata.get_granted_ddl('SYSTEM_GRANT', username) || '/' ddl
from dba_users
union all
select dbms_metadata.get_granted_ddl('OBJECT_GRANT', username) || '/' ddl
from dba_users;
