Database Administration (MOSC)

MOSC Banner

Resource Manager : Granting switch to a consumer group via a role does not work

edited Aug 5, 2013 7:15PM in Database Administration (MOSC) 5 commentsAnswered ✓
Hi,
Config: Oracle 11.2.0.3 EE on Linux and as well on 11.2.0.2 EE on AIX 7.1

Using Resource Manager, I'm having trouble to grant switch to a specific consumer group via a role. Here is what I did:

from the documentation:

If you grant permission to switch to a particular consumer group to a role, then any users who have been granted that role and have enabled that role can immediately switch their current consumer group to the new consumer group.



-- TEST CASE --
SET SERVEROUTPUT ON

BEGIN
-- 1 - Create the pending area
  SYS.DBMS_RESOURCE_MANAGER.clear_pending_area();
  SYS.DBMS_RESOURCE_MANAGER.create_pending_area();

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center