AV | SESSION_PRIV Function--Determine If Session Has a Privilege

SQL Language Guide > Working with Transactions and Handling Errors > Ways to Obtain Status Information > SESSION_PRIV Function--Determine If Session Has a Privilege

Was this helpful?

SESSION_PRIV Function--Determine If Session Has a Privilege

The SESSION_PRIV function determines whether the current session has a subject privilege, or can request it.

This function has the following format:

SESSION_PRIV('subject_priv')

where subject_priv is any single subject privilege name, such as operator, specified as a text string in upper or lower case. Valid subject privileges are listed under CREATE PROFILE.

The following values are returned:

Indicates session has privilege.

Indicates session does not have the privilege.

Indicates the session can request the privilege and make it active.

Example: The following checks whether the current session has auditor privilege:

SELECT SESSION_PRIV('AUDITOR');

Last modified date: 01/04/2024