Technical data

Specifying a Security Realm
Administration Guide 14-35
5. Define attributes for the JDBC driver being used to connect to the database.
The following table describes the attributes you set on the Database tab.
6. To save your changes, click the Apply button.
7. Define the schema used to store Users, Groups, and ACLs in the database in the
Schema Properties box on the Schema tab.
Listing 14-5 contains the database statements entered in the Schema properties
for the RDBMS code example shipped with WebLogic Server in the
/samples/examples/security/rdbmsrealm directory.
Listing 14-5 Sample Schema for RDBMS Security Realm
“getGroupNewStatement=true;getUser=SELECT U_NAME, U_PASSWORD FROM
users WHERE U_NAME = ?;
getGroupMembers=SELECT GM_GROUP, GM_MEMBER from groupmembers WHERE
GM_GROUP = ?;
getAclEntries=SELECT A_NAME, A_PRINCIPAL, A_PERMISSION FROM
aclentries WHERE A_NAME = ? ORDER BY A_PRINCIPAL;
getUsers=SELECT U_NAME, U_PASSWORD FROM users;
getGroups=SELECT GM_GROUP, GM_MEMBER FROM groupmembers;
getAcls=SELECT A_NAME, A_PRINCIPAL, A_PERMISSION FROM aclentries
ORDER BY A_NAME, A_PRINCIPAL;
getPermissions=SELECT DISTINCT A_PERMISSION FROM aclentries;
getPermission=SELECT DISTINCT A_PERMISSION FROM aclentries WHERE
A_PERMISSION = ?;
Table 14-14 RDBMS Security Realm Attributes on the Database Tab
Attribute Description
Driver Full class name of the JDBC driver. This class
name must be in the CLASSPATH of
WebLogic Server.
URL URL for the database you are using with the
RDBMS realm, as specified by your JDBC
driver documentation.
User Name Default user name for the database.
Password Password for the default user of the database.