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

SQL Anywhere 12.0.0 » SQL Anywhere Server - Database Administration » Configuring your database » Managing user IDs, authorities, and permissions » Managing user permissions and authorities

 

Granting authorities

You grant authorities in much the same way as you grant permissions.

 To grant an authority to a user ID (SQL)
  1. Connect to the database as a user with DBA authority.

  2. Execute a GRANT statement, specifying the authorities you are granting, and the user-id of the recipient.

For example, to grant DBA authority, the appropriate SQL statement is:

GRANT DBA TO user-id;

For more information about the supported authorities in SQL Anywhere, see Authorities overview.