edocs Home > Oracle WebLogic Server Documentation > Administration Console Online Help > Read Only SQL Authenticator: Provider Specific

Read Only SQL Authenticator: Provider Specific

Configuration Options     Related Tasks     Related Topics

Use this page to define the provider specific configuration for this Read-Only SQL Authentication provider.

Configuration Options

Name Description
Plaintext Passwords Enabled

Whether plaintext passwords are allowed to be used.

MBean Attribute:
DBMSAuthenticatorMBean.PlaintextPasswordsEnabled

Data Source Name

The data source used by this Read-Only SQL Authentication provider.

MBean Attribute:
ReadOnlySQLAuthenticatorMBean.DataSourceName

Group Membership Searching

Whether recursive group membership searching is unlimited or limited. Valid values are unlimited and limited.

MBean Attribute:
ReadOnlySQLAuthenticatorMBean.GroupMembershipSearching

Max Group Membership Search Level

This specifies how many levels of group membership can be searched. This setting is valid only if Group Membership Searching is set to limited. Valid values are 0 and positive integers. For example, 0 indicates only direct group memberships will be found, a positive number indicates the number of levels to go down.

MBean Attribute:
ReadOnlySQLAuthenticatorMBean.MaxGroupMembershipSearchLevel

SQL Get Users Password

The SQL statement used to look up a user's password. The SQL statement requires a single parameter for the username and must return a resultSet containing at most a single record containing the password.

MBean Attribute:
ReadOnlySQLAuthenticatorMBean.SQLGetUsersPassword

SQL User Exists

The SQL statement used to look up a user. The SQL statement requires a single parameter for the username and must return a resultSet containing at most a single record containing the user.

MBean Attribute:
ReadOnlySQLAuthenticatorMBean.SQLUserExists

SQL List Users

The SQL statement used to retrieve users that match a particular wildcard search The SQL statement requires a single parameter for the wildcarded usernames and returns a resultSet containing matching usernames

MBean Attribute:
ReadOnlySQLAuthenticatorMBean.SQLListUsers

SQL List Groups

The SQL statement used to retrieve group names that match a wildcard The SQL statement requires a single parameter for the wildcarded group name and return a resultSet containing matching group names

MBean Attribute:
ReadOnlySQLAuthenticatorMBean.SQLListGroups

SQL Group Exists

The SQL statement used to look up a group. The SQL statement requires a single parameter for the group name and must return a resultSet containing at most a single record containing the group

MBean Attribute:
ReadOnlySQLAuthenticatorMBean.SQLGroupExists

SQL Is Member

The SQL statement used to look up members of a group. The SQL statement requires two parameters: a group name and a member or group name. It must return a resultSet containing the group names that matched

MBean Attribute:
ReadOnlySQLAuthenticatorMBean.SQLIsMember

SQL List Member Groups

The SQL statement used to look up the groups a user or group is a member of. The SQL statement requires a single parameter for the username or group name and returns a resultSet containing the names of the groups that matched.

MBean Attribute:
ReadOnlySQLAuthenticatorMBean.SQLListMemberGroups

Descriptions Supported

Indicates whether user and group descriptions are supported by the database used by the authentication provider.

MBean Attribute:
ReadOnlySQLAuthenticatorMBean.DescriptionsSupported

SQL Get User Description

The SQL statement used to retrieve the description of a specific user. Only valid if Descriptions Supported is enabled. The SQL statement requires a single parameter for the username and must return a resultSet containing at most a single record containing the user description.

MBean Attribute:
ReadOnlySQLAuthenticatorMBean.SQLGetUserDescription

SQL Get Group Description

The SQL statement used to retrieve the description of a group. Only valid if Descriptions Supported is enabled. The SQL statement requires a single parameter for the group name and must return a resultSet containing at most a single record containing the group description.

MBean Attribute:
ReadOnlySQLAuthenticatorMBean.SQLGetGroupDescription

Related Tasks

Related Topics