SQL standard authorization exceptions

SQL exceptions are returned when errors occur with SQL authorization.

The following errors can result from the CREATE ROLE statement:

The following errors can result from the DROP ROLE statement:

The following errors can result from the SET ROLE statement:

The following errors can result from the GRANT statement:

The following errors can result from the REVOKE statement:

For all statements, an attempt to specify an identifier argument more than 128 characters long raises the SQLException 42622.

Related concepts
Using SQL standard authorization
Privileges on views, triggers, and constraints
Using SQL roles