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()

Parameters

The following table shows the GET_ROLE_PERMISSIONS parameters:

Parameter

Description

()

The permissions belonging to the role.

Output

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

Example

The following is an example of using the GET_ROLE_PERMISSIONS statement:

select get_role_permissions();

Permissions

Using the GET_ROLE_PERMISSIONS statement requires no special permissions.

For more information, see the following: