Error while granting role to user using procedure

[Former Member]

Hi,

Facing issue while granting role to current user

call "_SYS_REPO"."GRANT_ACTIVATED_ROLE"('"TestXSProject.data::sridharrole"','SYSTEM');

Error: can only grant  activated roles.

But the role is active. otherwise please let me know, how to check whether the role is active or not.

[Former Member · Accepted solution]

'"TestXSProject.data::sridharrole"'

why do you combine ' and " here?

I suggest to use only one..