AUTHORIZATION_IDENTIFIERS View

The AUTHORIZATION_IDENTIFIERS view displays Authentication Server objects (users and groups) that have been resolved on SAS Federation Server. This view also shows inactive records for SAS Federation Server which are records created when an object is removed from the Authentication Server. Removing an object from the Authentication Server does not remove it from the AUTHORIZATION_IDENTIFIERS view. Use the DROP AUTHID | AUTHORIZATION IDENTIFIERDDL statement to remove these objects from the AUTHORIZATION_IDENTIFIERS view.
The following table lists the columns that will be displayed:
Name
Type
Description
NAME
VARCHAR(256)
Specifies the name of a group, role, or user that was created using the Authentication Server. NULL is displayed if the group, role, or user is orphaned.
ID
VARCHAR(256)
Specifies the authorization identifier from the Authentication Server.
TYPE
CHAR(1)
Specifies the type of entity as G (Group) or U (User).
Only System or Federation Server administrators can view data in the AUTHORIZATION_IDENTIFIERS view. All users can query the AUTHORIZATION_IDENTIFIERS view, but the query will return an empty result set if the user is not a system user or SAS Federation Server administrator.