server wide roles and database specific roles

crazy_monk wrote:
> what is the difference between server wide roles and database specific
> roles,where do u find them and what is the scope?

I suppose that you mean database groups where you say database
specific roles.

- groups exist in sybase since the beginning, roles were added
later and are conform (or close to) the sql standard.

- users can only belong to one group in a database. This is a
nightmare if you have a lot of different type of users.
users can belong to multiple roles.

- if you have a guest user in your databases, you don't need to
add users to a database anymore. It's sufficient to grant them
the roles they require.

I'm converting groups to roles.

Luc.