Logo

SQL Script

Grant Resource Manager Privileges

 Tested on Oracle 8.1

Updated : 30-July-2002
Version : 1.0

Description

This script assigns a resource manager plan to users.

Parameters

&1 - The resource consumer group

&2 - The user to be assigned the consumer group

SQL Source

set verify off

define consumer_group = UPPER('&1')
define user = UPPER('&2')

begin
 
dbms_resource_manager_privs.grant_switch_consumer_group  
      ( grantee_name => &user
      , consumer_group => &consumer_group
      , grant_option => FALSE);

dbms_resource_manager.set_initial_consumer_group
     (user => &user
     ,consumer_group  => &consumer_group ); 

end;
/

exit

Return to Index of SQL Scripts

Home | Company Profile | Services | Contact Us | SQL scripts and tips | Quiz
Legal

Logo