AUTHORIZATIONIDS administrative view - Retrieve authorization IDs and types
The
AUTHORIZATIONIDS administrative view returns a list of all the users,
roles, and groups that exist in the database catalog of the currently
connected server as a result of GRANT statements.
Each
authorization ID and associated type that is returned by the view
has at least one privilege, authority, or role membership. The users
that are currently members of any of the groups are not included in
the result.
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
- DBADM authority
- SQLADM authority
- ACCESSCTRL authority
- SECADM authority
Default PUBLIC privilege
In a non-restrictive database, SELECT privilege is granted to PUBLIC when the view is automatically created.
Example
Retrieve all authorization IDs that
have been granted privileges or authorities, along with their types.
SELECT * FROM SYSIBMADM.AUTHORIZATIONIDS
The following
is an example of output for this query.
AUTHID AUTHIDTYPE
-------------------------...------- ----------
PUBLIC G
JESSICAE U
DOCTOR R
3 record(s) selected.
Information returned
Column name | Data type | Description |
---|---|---|
AUTHID | VARCHAR(128) | Authorization ID that has been explicitly granted privileges or authorities. |
AUTHIDTYPE | CHAR(1) | Authorization ID type:
|