on 09-27-2012 11:25 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.