SQL Script Grant Resource Manager Privileges

Updated: 30-Jul-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

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

rem=============================================================
rem grant_rsrc.sql
rem
rem This scripts grants the privileges needed to set a user in a database
rem resource manager consumer group.
rem
rem PARAMETERS:
rem 1: Consumer Group
rem 2: Username to be granted
rem
rem MODIFICATION HISTORY:
rem
rem Who   Date        Reason
rem ---   ----        ------
rem DEA   02-Apr-2002 Original 
rem=============================================================

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

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links