Page 1 of 1

Grant role/schema via _sys_repo

Posted: Thu Sep 12, 2013 7:41 am
by Hay Bouten
Newly created roles can be granted to users by calling the following function.

Code: Select all

call "_SYS_REPO"."GRANT_ACTIVATED_ROLE"('[role]','[user]');
Grant right to schema with:

Code: Select all

GRANT SELECT ON SCHEMA  "your user" TO _SYS_REPO WITH GRANT OPTION;