Thursday, July 05, 2007

Create a Sybase Group

Creating a group in a Sybase database is an easy task. You will need to use the sp_addgroup stored procedure to accomplish the task. Here is the syntax for the current database.

# isql -Usa -Ppassword
1> use esoftdb
2> go
1> sp_addgroup esoftdb_group
2> go

Determine groups in a database
# isql -Usa -Ppassword
1> use esoftdb
2> go
1> sp_helpgroup
2> go

Determine users in a specific group
1> sp_helpgroup esoftdb_group
2> go

No comments: