AUTHORIZATION_IDENTIFIERS

The AUTHORIZATION_IDENTIFIERS view displays SAS Metadata 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 SAS Metadata Server. Removing an object from the SAS Metadata Server does not remove it from the AUTHORIZATION_IDENTIFIERS view. Use the DROP AUTHID | AUTHORIZATION IDENTIFIER DDL 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 SAS Metadata Server. NULL is displayed if the group, role, or user is orphaned.
ID	VARCHAR(256)	Specifies the authorization identifier from the SAS Metadata 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.

Last updated: March 6, 2018