Sybase group is a logical organization of users who will be granted common permissions. Sybase Group simplifies the addition of users to databases. We can set up the permissions one time, then add users directly to the groups. Groups are database specific. A user can be placed only in one group.
1. Create group name rwgroup in the database r2schools.
sp_addgroup rwgroup go
2. Grant select permissions to group ‘rwgroup’ on table ’employee’
grant select on employee to rwgroup go
3. Add user ‘george’ to group ‘rwgroup’
sp_adduser george go sp_changegroup rwgroup,george go
4. To check the user is added to group or not.
sp_helpuser george go
To verify:
To get list of users added to Sybase Group.
sp_helpgroup rwgroup go
To get the list of group permissions.
sp_helprotect rwgroup go