Bookshelf Home | Contents | Index | PDF |
Siebel Business Analytics Server Administration Guide > Security in Siebel Business Analytics > Authentication Options > Setting Up External Table AuthenticationInstead of storing user IDs and passwords in an analytics 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 Business 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 Setting Up Database Authentication, and Order of Authentication for additional details. External table authentication uses Siebel Business Analytics session variables that you define using the Variable Manager of the Administration Tool. For more information about the Variable Manager, see Using the 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 that 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 about 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 more information, see Setting Up LDAP Authentication. To set up external table authentication
|
Siebel Business Analytics Server Administration Guide |