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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Managing User IDs and Permissions » Managing individual user IDs and permissions

Setting user and group options Next Page

Granting DBA and RESOURCE authority

You can grant DBA and RESOURCE authority in the same manner.

To grant RESOURCE authority to a user ID
  1. Connect to the database as the DBA.

  2. Execute the SQL statement:

    GRANT RESOURCE TO user-id;
  3. For DBA authority, the appropriate SQL statement is:

    GRANT DBA TO user-id;