cancel
Showing results for 
Search instead for 
Did you mean: 

copy roles

Former Member
0 Kudos

HI all, i have to creat a new user,but want all the roles of the system user is there any Sql for this? as i have lot of roles for all previlages

i am using 35 version on hana studio

regards

Siva

Accepted Solutions (0)

Answers (1)

Answers (1)

lucas_oliveira
Advisor
Advisor
0 Kudos

Hi Siva,
As of now there's no feature to copy a user, role or privileges. However, you could check the GRANTED_ROLES administration view and get the info regarding the granted roles of SYSTEM user. I believe this sql should get you the roles assigned:

SELECT ROLE_NAME

FROM   GRANTED_ROLES

WHERE  GRANTEE = 'SYSTEM'

Let me know if this helps you somehow.

Regards,

Lucas de Oliveira