createtempuser.sql

来自「本书是Oracle 9i的基础培训教程,适用于Oracle初学者和有基本了解的人」· SQL 代码 · 共 22 行

CREATE USER "TEMPUSER"  PROFILE "DEFAULT" 
    IDENTIFIED BY "tempuser" DEFAULT TABLESPACE "USERS" 
    ACCOUNT UNLOCK;
GRANT CREATE ANY TABLE TO "TEMPUSER" WITH ADMIN OPTION;
GRANT "CONNECT" TO "TEMPUSER" WITH ADMIN OPTION;


BEGIN
	dbms_resource_manager_privs.grant_switch_consumer_group( 
		grantee_name => 'TEMPUSER',
		consumer_group => 'DEFAULT_CONSUMER_GROUP',
		grant_option => TRUE
	);
END;


BEGIN 
	dbms_resource_manager.set_initial_consumer_group( 
		user => 'TEMPUSER',
		consumer_group => 'DEFAULT_CONSUMER_GROUP'
	);
END;