Privileges Associated with a Role

----------------------------------
-Privileges Associated with a Role
-File Name: role_privs.sql
-Usage: @role_privs
-----------------------------------

select PRIVILEGE from role_sys_privs where ROLE='&role'
/