Bookshelf Home | Contents | Index | PDF |
Siebel Analytics Server Administration Guide > Security in Siebel Analytics > Authentication Options > External Table AuthenticationInstead of storing user IDs and passwords in a Siebel Analytics Server repository, you can maintain lists of users and their passwords in an external database table and use this table for authentication purposes. The external database table contains user IDs and passwords, and could contain other information, including group membership and display names used for Siebel Analytics Web users. The table could also contain the names of specific database catalogs or schemas to use for each user when querying data. NOTE: If a user belongs to multiple groups, the group names should be included in the same column separated by semicolons. External table authentication can be used in conjunction with database authentication. If external table authentication succeeds, then database authentication is not performed. If external table authentication fails, then database authentication is performed. See Database Authentication, and Order of Authentication for additional details. Setting Up External Table AuthenticationExternal table authentication uses Siebel Analytics session variables, which you define using the Variable Manager of the Administration Tool. For more information about the Variable Manager, see Using the Analytics Variable Manager. Session variables get their values when a user begins a session by logging on. Certain session variables, called system variables, have special uses. The variable USER is a system variable that is used with external table authentication. To set up external table authentication, you define a system variable called USER and associate it with an initialization block, which is associated with an external database table. Whenever a user logs in, the user ID and password will be authenticated using SQL that queries this database table for authentication. After the user is authenticated successfully, other session variables for the user could also be populated from the results of this SQL query. For more information on session variables, see About Session Variables. The presence of a defined system variable USER determines that external authentication is done. Associating USER with an external database table initialization block determines that the user will be authenticated using the information in this table. To provide other forms of authentication, associate the USER system variable with an initialization block associated with a LDAP server or XML source. For details, see LDAP Authentication. To set up external table authentication
|
Siebel Analytics Server Administration Guide |