GET_ROLE_PERMISSIONS

The GET_ROLE_PERMISSIONS statement returns all permissions granted to a role in table format.

The GET_ROLE_PERMISSIONS page describes the following:

Syntax 

The following is the correct syntax for using the GET_ROLE_PERMISSIONS statement:

select get_role_permissions()

The following is an example of using the GET_ROLE_PERMISSIONS statement:

select get_role_permissions();

The following table shows the GET_ROLE_PERMISSIONS parameters:

Parameter	Description
`()`	The permissions belonging to the role.

The following is an example of the output of the GET_ROLE_PERMISSIONS statement:

Parameter	Description	Example
`permission_type`	The permission type granted to the role.	SUPERUSER
`object_type`	The data object type.	table
`object_name`	The name of the object.	master.public.nba

Using the GET_ROLE_PERMISSIONS statement requires no special permissions.

For more information, see the following: