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@xxxxxxxxx> 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