Chapter 3 DBMS Reference Guide
The Role category is located in the Root→Script→Objects 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. |
| Copyright (C) 2007. Sybase Inc. All rights reserved. |
| |