The Role category is located in the category, and can contain the following items that define how roles are modeled for your DBMS.
|
Item |
Description |
|---|---|
|
[Common items] |
The following common object items may be defined for roles: For a description of each of these common items, see Common object items. |
|
Bind |
Specifies a command for adding a role to a user or to another role. Example (ASE 15): grant role %ROLE% to %USER% |
|
SqlListChildren Query |
Specifies a SQL query for listing the members of a group. Example (ASE 15): { ROLE ID, MEMBER }
SELECT r.name, u.name
FROM
master.dbo.sysloginroles l,
[%CATALOG%.]dbo.sysroles s,
[%CATALOG%.]dbo.sysusers u,
[%CATALOG%.]dbo.sysusers r
where
l.suid = u.suid
and s.id =l.srid
and r.uid = s.lrid
|
|
Unbind |
Specifies a command for removing a role from a user or another role. |