Grant role/schema via _sys_repo

[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;