My webMethods Server 10.1 | My webMethods Server Webhelp | Document Conventions | My webMethods Administrator Functions | Managing Roles and Access to My webMethods | Creating Roles | Adding a Database Role
 
Adding a Database Role
A database role is based on a query to a database directory service. Any user, group, or role that matches the rule is a member of the role.
Note:
To create a database role, you must first connect to the database as an external data source. See Managing External Data Sources.
*To create a database role
1. To navigate to the correct page, do one of the following:
*In My webMethods: Navigate > Applications > Administration > System-Wide > User Management > Roles > Add Role.
*As system administrator: Administration Dashboard > User Management > Manage Roles > Add Role.
2. In the Role Name field, type the name that you want to assign to the new role.
Valid role names can contain only letters, numbers, an underscore, or a space character.
3. To select the Database Role Provider, move that role provider to the Selected Items box.
4. Click Create Role.
5. From the Datasource list, select the database to be used as a data store.
6. If the role can include users, in the Query User field, type a SQL query that returns a record for a given user in the database who should be a member of the role.
The parameters to the query are:
*{uid}—Principal unique ID
*{dn}—Principal distinguished name
An example of a valid query is:
select * from user-roles where roleID=‘Admin’ and userid=‘{uid}’
7. If the role can include groups, in the Query Group field, type a SQL query that returns a record for a given group in the database that should be a member of the role.
8. Click Save.