Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Configuring Your Database » Managing user IDs, authorities, and permissions » Managing groups

 

Creating groups

♦  To create a new group (Sybase Central)
  1. Connect to the database as a user with DBA authority.

  2. Right-click Users & Groups and then choose New » Group.

  3. Follow the instructions in the Create Group Wizard.

♦  To create a new group (SQL)
  1. Connect to the database as a user with DBA authority.

  2. Execute a GRANT GROUP TO statement. If the user ID you specify in this statement has not been created, the statement fails.

Example

Create the user ID personnel.

CREATE USER personnel
IDENTIFIED BY group_password;

Make the user ID personnel a group.

GRANT GROUP TO personnel;
See also