Users and Groups - Domains
Selecting the Domains option, under User and Groups, will display the list of available domains. The following information is accessible:
Columns
| Name | The Name field contains the name assigned to the information contained in the Value field. |
|---|---|
| Value |
The Value field contains the SQL data used to extract users and groups. This field will be filled in according to the template selected. Values may be customized by double-clicking in the field.
Example: SELECT DISTINCT usrname, '' FROM maxusergroups
|
| Description | The Description field has a short description of what is contained in the Value field. This is an informational field only and is not used by DataSplice. |
The Value fields in domain can be modified to configure the domain to search for users and groups based on a company's individual needs. The following settings are available to change:
| SQLUsers |
This field indicates the SQL statement to use for determining the users in this domain. The following SQL Statement is an example of how to query Oracle for the list of users:
SELECT DISTINCT username, '' FROM dba_users
Note: The %VAR% syntax is required by DataSplice to perform variable substitution for the login name of the user being validated.
|
|---|---|
| SQLGroups |
This field indicates the SQL statement to use for determining the groups in this domain.
The following SQL Statement is an example of how to query Oracle for the list of groups (roles):
SELECT DISTINCT role, '' FROM dba_roles
|
| SQLUserGroups |
This field indicates the SQL statement to use for determining the groups a user belongs to.
The following SQL Statement is an example of how to query Oracle for the groups (roles) a user is member of:
SELECT DISTINCT granted_role, grantee FROM dba_role_privs WHERE grantee = %VAR%
Note: The %VAR% syntax is required by DataSplice to perform variable substitution for the login name of the user being validated.
|
| SQLGroupUsers |
This field indicates the SQL statement to use for determining the users that are members of a group.
The following SQL Statement is an example of how to query Oracle for the users that are a member of a particular group (role):
SELECT DISTINCT grantee, granted_role FROM dba_role_privs WHERE granted_role = %VAR%
Note: The %VAR% syntax is required by DataSplice to perform variable substitution for the group (role) being validated.
|
| DSN | This field indicates which ODBC Data Source to use. |
| AdminUID | This field indicates the login name to use when connecting to the Data Source. |
| AdminPWD | This field indicates the password for the login name specified in AdminUID. |
| UseCursorLib | This field indicates whether or not to use the ODBC Cursor Library. |
- Expand the Users and Groups section in the left pane by clicking on the plus/minus sign.
- Open the Domains section
- Click the Add Domain button
in the toolbar. - The Create External Domain dialog box will appear.
- Enter a name for the domain.
- Select an Authentication Module.
- A list of templates will appear.
- Select the appropriate template.
- Click OK.
The template domain will now appear in the list of domains. Changes must be made to the template in order to populate the domain.
