Need help with ORA-20067: grantee must be an existing user, an existing role or PUBLIC
Hi, my Oracle version is 11gR2. I'm a newbie to Oracle DB. I logged in as system and create a new user. I then tried to grant system privilege by executing:
BEGIN DBMS_WM.GrantSystemPriv('ACCESS_ANY_WORKSPACE','mynewtester','NO'); END;
It returned the error:
ORA-20067: grantee must be an existing user, an existing role or PUBLIC
ORA-06512: at "WMSYS.LT", line 10168
ORA-06512: at line 1
I'm not sure what it means and I searched on the work space management. I tried to set the user with WM_ADMIN_ROLE or DBA, DBA_WITH_ADMIN_OPTION role first and then run the above command, but it still failed with the same error.
BEGIN DBMS_WM.GrantSystemPriv('ACCESS_ANY_WORKSPACE','mynewtester','NO'); END;
It returned the error:
ORA-20067: grantee must be an existing user, an existing role or PUBLIC
ORA-06512: at "WMSYS.LT", line 10168
ORA-06512: at line 1
I'm not sure what it means and I searched on the work space management. I tried to set the user with WM_ADMIN_ROLE or DBA, DBA_WITH_ADMIN_OPTION role first and then run the above command, but it still failed with the same error.
0