Skip to Content
0
Nov 20, 2020 at 04:10 PM

Assign HANA Role(hbrole - MTA) to User

97 Views Last edit Nov 20, 2020 at 04:14 PM 2 rev

Hi ,

I have created a hdbrole in mta project which creates a role in the system . The role provides a SELECT access to the classic schema. We used to run the below procedure and the _SYS_REPO assigns the role to user in XS Classic.


CALL _SYS_REPO.GRANT_ACTIVATED_ROLE('Role_name','USER')


Can we also do something similar for the roles created via MTA project . I mean assigning to any particular user via technical user. We do not want to assign a role to a user in production by one of the normal users or we should always use SYSTEM user?.