You grant authorities in much the same way as you grant permissions.
To grant an authority to a user ID
Connect to the database as a user with DBA authority.
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.
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |