Grant role/schema via _sys_repo

Do you have information on SAP HANA Technology (Suse Linux, HANA Patches, DMIS and so on) then post it here.
Post Reply
User avatar
Hay Bouten
Posts: 131
Joined: Mon Dec 24, 2012 10:11 am
Location: Eindhoven, The Netherlands
Contact:

Grant role/schema via _sys_repo

Post by Hay Bouten » Thu Sep 12, 2013 7:41 am

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;

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest