query to get all roles,security context and security context value (without users)
Summary:
Hi
I need help in getting the roles ,security context and security context values for all the roles defined (without USERS).
created the below query could you please let me know if query holds good to retrieve the information
Select
to_char(roles.role_id) role_id,to_char(roles.role_common_name) role_common_name,
to_char(replace(replace (replace(Security_Context,CHR(13),' '),CHR(10),''),CHR(9),' ')) as Security_Context,
to_char(replace(replace (replace(Security_Context_Value,CHR(13),' '),CHR(10),''),CHR(9),' ')) as Security_Context_Value,
replace(to_char(roles.description),'\n',' ') description,
Tagged:
0