Hi,

can user-defined role be granted to a group?

i tried the following commands:

----------
create role my_role
exec sp_addgroup my_group
go

sp_role 'grant', my_role, my_group
or:
grant role my_role to my_group
----------
Error: No such user/role 'my_group' exists.
----------

in System Administration Guide i found:

System Security Officer privileges:
"System Security Officers can also create and grant user-defined roles
to users, other roles, or groups."

Granting and revoking roles:
"A role can only be granted to a login account or another role."

so, finally, is it possible and how to grant user-defined role to a
group?

i'm running ASE 11.9.2

thanks

lena (AT) tippcom (DOT) co.il (Lena) wrote in message news:<ab84434f.0408040446.3e871919 (AT) posting (DOT) google.com>...
No, it is not possible. Doc Bug 302903 has corrected this in the
manuals. Note that 11.9.2 has been end-of-lifed and 12.0 soon
will be; I recommend upgrading to 12.5.2.

-bret