Re: Executing DBMS_RESOURCE_MANAGER_PRIVS in ATP

From: Arpit Aggarwal <arpitdba2019_at_gmail.com>
Date: Mon, 11 Nov 2019 11:51:26 +0530
Message-ID: <CAOrSwEr01NvcMgo8aOfi2Pd8U7XNh9DR7ZamOGH8J5mrhJ6v+w_at_mail.gmail.com>

Hi Experts,

Has anyone tried changing a consumer group for a user in ATP database from its default consumer group.
I have logged in as admin user and trying to change consumer group from sql developer but it says package is not declared. Tried giving it by appending SYS but it's still same.

I cannot login as SYS user as it's not provided in ATP database.

BEGIN
SYS.DBMS_RESOURCE_MANAGER_PRIVS.grant_switch_consumer_group(

    grantee_name   => 'LOADTEST',
    consumer_group => 'TP',
    grant_option   => FALSE);

END;
/

Error :-

Error starting at line : 3 in command -
BEGIN
SYS.DBMS_RESOURCE_MANAGER_PRIVS.grant_switch_consumer_group(

    grantee_name   => 'LOADTEST',
    consumer_group => 'TP',
    grant_option   => FALSE);

END;
Error report -

ORA-06550: line 2, column 1:
PLS-00201: identifier 'SYS.DBMS_RESOURCE_MANAGER_PRIVS' must be declared
ORA-06550: line 2, column 1:

PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:\n%s" *Cause: Usually a PL/SQL compilation error. *Action:

Thanks,
Arpit

On Thu, 7 Nov 2019 at 17:27, Arpit Aggarwal <arpitdba2019_at_gmail.com> wrote:

> Hi Experts,
>
> Has anyone tried changing a consumer group for a user in ATP database.
> I have logged in as admin user and trying to change consumer group from
> sqldeveloper but it says package is not declared. Tried giving it by
> appending SYS but it's still same.
>
> I cannot login as SYS user as I don't have its logins.
>
> BEGIN
> SYS.DBMS_RESOURCE_MANAGER_PRIVS.grant_switch_consumer_group(
> grantee_name => 'LOADTEST',
> consumer_group => 'TP',
> grant_option => FALSE);
> END;
> /
>
> Error :-
>
>
> Error starting at line : 3 in command -
> BEGIN
> SYS.DBMS_RESOURCE_MANAGER_PRIVS.grant_switch_consumer_group(
> grantee_name => 'LOADTEST',
> consumer_group => 'TP',
> grant_option => FALSE);
> END;
> Error report -
> ORA-06550: line 2, column 1:
> PLS-00201: identifier 'SYS.DBMS_RESOURCE_MANAGER_PRIVS' must be declared
> ORA-06550: line 2, column 1:
> PL/SQL: Statement ignored
> 06550. 00000 - "line %s, column %s:\n%s"
> *Cause: Usually a PL/SQL compilation error.
> *Action:
>
>
> Thanks,
> Arpit
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 11 2019 - 07:21:26 CET