GET_ROLE_GLOBAL_DDL

The GET_ROLE_GLOBAL_DDL statement returns the definition of a global role in DDL format.

The GET_ROLE_GLOBAL_DDL page describes the following:

Syntax

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

select get_role_global_ddl(<'role_name'>)

Example

The following is an example of using the GET_ROLE_GLOBAL_DDL statement:

select get_role_global_ddl('public');

Parameters

The following table shows the GET_ROLE_GLOBAL_DDL parameters:

Parameter

Description

role_name

The definition of the global role in DDL format.

Output

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

create role "public";

Permissions

Using the GET_ROLE_GLOBAL_DDL statement requires no special permissions.

For more information, see the following: