oracle创建一个用户的完整命令

实例:


CREATE USER "TESTUSER" PROFILE "DEFAULT"
    IDENTIFIED BY "hawkingwan" DEFAULT TABLESPACE "USERS"
    QUOTA 10 M
    ON "USERS"
    ACCOUNT UNLOCK;
GRANT ALTER ANY TABLE TO "TESTUSER" WITH ADMIN OPTION
GRANT SELECT ON "HR"."EMPLOYEES" TO "TESTUSER"
GRANT "CONNECT" TO "TESTUSER" WITH ADMIN OPTION;
BEGIN
    dbms_resource_manager_privs.grant_switch_consumer_group(
        grantee_name => 'TESTUSER',
        consumer_group => 'DEFAULT_CONSUMER_GROUP',
        grant_option => TRUE
    );
END;
BEGIN
    dbms_resource_manager.set_initial_consumer_group(
        user => 'TESTUSER',
        consumer_group => 'DEFAULT_CONSUMER_GROUP'
    );
END;