RDB$SYSTEM_PRIVILEGE()

Procedural SQL (PSQL) StatementsAggregate Functions

`RDB$SYSTEM_PRIVILEGE()`

Checks if the authorization of the current connection has a system privilege

Result type

BOOLEAN

Syntax

RDB$SYSTEM_PRIVILEGE (<sys_privilege>)

<sys_privilege> ::=
  !! See CREATE ROLE !!

Table 1. `RDB$SYSTEM_PRIVILEGE` Function Parameters
Parameter	Description
sys_privilege	System privilege

RDB$SYSTEM_PRIVILEGE accepts a system privilege name and returns TRUE if the current connection has the given system privilege, and FALSE otherwise.

The authorization of the current connection is determined by privileges of the current user, the user PUBLIC, and the currently active roles (explicitly set or activated by default).

`RDB$SYSTEM_PRIVILEGE` Examples

select rdb$system_privilege(user_management) from rdb$database;

RDB$SYSTEM_PRIVILEGE()

RDB$SYSTEM_PRIVILEGE()

RDB$SYSTEM_PRIVILEGE Examples

`RDB$SYSTEM_PRIVILEGE()`

`RDB$SYSTEM_PRIVILEGE` Examples