Differences

This shows you the differences between two versions of the page.

--- recreate_objects_using_dbms_metadata.get_ddl [2018/12/06 21:05] – created 91.177.234.129
+++ recreate_objects_using_dbms_metadata.get_ddl [2019/01/30 11:32] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-====== Recreate_objects_using_dbms_metadata.get_ddl ======
+==== Recreate all the users (including grants) in a database ====
+<code>
-=====Recreate all the users (including grants) in a database=====
  select dbms_metadata.get_ddl('USER', username) || '/' ddl
  from dba_users
@@ Line 13: / Line 12: @@
  select dbms_metadata.get_granted_ddl('OBJECT_GRANT', username) || '/' ddl
  from dba_users;