Grant role/schema via _sys_repo
Posted: Thu Sep 12, 2013 7:41 am
Newly created roles can be granted to users by calling the following function.
Grant right to schema with:
Code: Select all
call "_SYS_REPO"."GRANT_ACTIVATED_ROLE"('[role]','[user]');
Code: Select all
GRANT SELECT ON SCHEMA "your user" TO _SYS_REPO WITH GRANT OPTION;