GET ALL ROLES DATABASE DDL

The GET ALL ROLES DATABASE DDL statement returns the definition of all role databases in DDL format.

Syntax

select get_all_roles_database_ddl()

Example

select get_all_roles_database_ddl();

Output

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

grant create, usage on schema "public" to "public" ; alter default schema for "public" to "public"; alter default permissions for "public" for schemas grant superuser to creator_role ; alter default permissions for "public" for tables grant select, insert, delete, ddl, update to creator_role ; grant select, insert, delete, ddl, update on table "public"."customer" to "sqream" ; grant select, insert, delete, ddl, update on table "public"."d_customer" to "sqream" ; grant select, insert, delete, ddl, update on table "public"."demo_customer" to "sqream" ; grant select, insert, delete, ddl, update on table "public"."demo_lineitem" to "sqream" ; grant select, insert, delete, ddl, update on table "public"."lineitem" to "sqream" ; grant select, insert, delete, ddl, update on table "public"."nation" to "sqream" ; grant select, insert, delete, ddl, update on table "public"."orders" to "sqream" ; grant select, insert, delete, ddl, update on table "public"."part" to "sqream" ; grant select, insert, delete, ddl, update on table "public"."partsupp" to "sqream" ; grant select, insert, delete, ddl, update on table "public"."region" to "sqream" ; grant select, insert, delete, ddl, update on table "public"."supplier" to "sqream" ; alter default schema for "sqream" to "public";

Permissions

Using the GET ALL ROLES DATABASE DDL statement requires no special permissions.

For more information, see the following:

• GET ALL ROLES GLOBAL DDL

• GET ROLE PERMISSIONS