Role

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:

  • AfterCreate, AfterDrop, AfterModify

  • BeforeCreate, BeforeDrop, BeforeModify

  • Create, Drop

  • Enable

  • Maxlen

  • ModifiableAttributes

  • ReversedQueries, ReversedStatements

  • SqlAttrQuery, SqlListQuery, SqlPermQuery

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.