DB2 Version 9.7 for Linux, UNIX, and Windows

AUTHORIZATIONIDS administrative view - Retrieve authorization IDs and types

The AUTHORIZATIONIDS administrative view returns a list of authorization IDs that have been granted privileges or authorities, along with their types, for all authorization IDs defined in the system catalogs from the currently connected database. If privileges or authorities have been granted to groups or roles, only the group or role names are returned.

The schema is SYSIBMADM.

Authorization

One of the following authorizations is required:

SELECT privilege on the AUTHORIZATIONIDS administrative view
CONTROL privilege on the AUTHORIZATIONIDS administrative view
DATAACCESS authority

Example

Retrieve all authorization IDs that have been granted privileges or authorities, along with their types.

SELECT * FROM SYSIBMADM.AUTHORIZATIONIDS

The following example is a sample output for this query.

AUTHID                              AUTHIDTYPE
-------------------------...------- ----------
PUBLIC                              G         
JESSICAE                            U         
DOCTOR                              R

  3 record(s) selected.

Information returned

Table 1. Information returned by the AUTHORIZATIONIDS administrative view
Column name	Data type	Description
AUTHID	VARCHAR(128)	Authorization ID that has been explicitly granted privileges or authorities.
AUTHIDTYPE	CHAR(1)	Authorization ID type: U: user R: role G: group