User Creation

User Creation

 Model ID     : USER1

 New Username : NEWUSER

select dbms_metadata.get_ddl('USER', 'USER1') meta from dual;

      CREATE USER "USER1" IDENTIFIED BY "passowrd"

             DEFAULT TABLESPACE "USERS"

        TEMPORARY TABLESPACE "TMP"

            quota 10g on users

            password expire;      

select DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','USER1') from dual;

            GRANT CREATE VIEW TO "USER1"

            GRANT SELECT ANY TABLE TO "USER1"

            GRANT CREATE TABLE TO "USER1"

            GRANT CREATE SESSION TO "USER1"

select DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT','USER1') from dual;

            no rows selected

select DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','USER1') from dual;