To Get the USER DDL WITH GRANTS

To get the USER DDL with grant issue below command.

USER DDL

       




SELECT dbms_metadata.get_ddl('USER','username')  FROM dual;


       
 

SYSTEM_GRANT DDL

       




SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','username') from dual;



       
 

ROLE_GRANT DDL

       




SELECT DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT','username') from dual;



       
 

OBJECT_GRANT DDL

       




SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','username') from dual;



       
 

THANKS.