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:
Post a Comment