Thursday, July 05, 2007

Change a Sybase User's Group

Changing a user's group in Sybase is another fairly straightforward task. A user only belongs to two groups. The assigned group and default group, which is "public." You will need to use the sp_changegroup stored procedure to accomplish this task. Here is an example.

The user "esofthub" belongs to the mynewgroup and public.

1> sp_changegroup mynewgroup, esofthub
2> go

To remove a user from a group affiliation, here's an example.

1> sp_changegroup "public", esofthub
2> go

No comments: