Oracle创建用户

            CREATE
            TEMPORARY
             TABLESPACE test_temp
TEMPFILE 
            ‘
            C:oracleproduct10.1.0oradataorcltest_temp01.dbf
            ‘
            
SIZE 32M
AUTOEXTEND 
            ON
            NEXT
             32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
        

            CREATE
             TABLESPACE test_data
LOGGING
DATAFILE 
            ‘
            C:ORACLEPRODUCT10.1.0ORADATAORCLTEST_DATA01.DBF
            ‘
             
SIZE 32M 
AUTOEXTEND 
            ON
            NEXT
             32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
        

            CREATE
            USER username IDENTIFIED BY password
DEFAULT TABLESPACE TEST_DATA
TEMPORARY TABLESPACE TEST_TEMP;

            GRANT
            CREATE SESSION, CREATEANYTABLE, CREATEANYVIEW ,CREATEANYINDEX, CREATEANYPROCEDURE,
　　ALTERANYTABLE, ALTERANYPROCEDURE,
　　DROPANYTABLE, DROPANYVIEW, DROPANYINDEX, DROPANYPROCEDURE,
　　SELECTANYTABLE, INSERTANYTABLE, UPDATEANYTABLE, DELETEANYTABLETO username;

            GRANT role TO username;

            SELECT
            *
            FROM
             DBA_USERS;

            SELECT
            *
            FROM
             ALL_USERS;

            SELECT
            *
            FROM USER_USERS;

            SELECT
            *
            FROM
             DBA_SYS_PRIVS;

            SELECT
            *
            FROM USER_SYS_PRIVS;

            SELECT
            *
            FROM
             DBA_TAB_PRIVS;

            SELECT
            *
            FROM
             ALL_TAB_PRIVS;

            SELECT
            *
            FROM USER_TAB_PRIVS;

            SELECT
            *
            FROM DBA_ROLES;

            SELECT
            *
            FROM
             DBA_ROLE_PRIVS;

            SELECT
            *
            FROM USER_ROLE_PRIVS;

            --
            -----遇到no privileges on tablespace ‘tablespace ‘
            alter
            user userquota 10M[unlimited]on tablespace;