Sybase has Role at the server level and Group at the database level. What is
the criteria to use a Role rather than a Group and Viceversa?

-Rp©

The big difference is that a user can

only be part of 1 group other than 'public'.
while
it can be part of many roles

If you have 2 groups 'readonly' and 'updateonl'y. You can give a user
read or update perrmission but not both. Had they been roles, you could
have given a user both read and update permissions.

Karl

"Rajesh" <r@h.c> wrote in message
news:QA1Qa.4785$Y92.3510@nwrdny01.gnilink.net...
> Sybase has Role at the server level and Group at the database level. What
is
> the criteria to use a Role rather than a Group and Viceversa?
>
> -Rp©
>
>