In SQL Anywhere, authorities can be thought of as database-level permissions. As such, they are not necessarily associated with any object within the database (other than the user). For example, a user with BACKUP authority is allowed to back up the database. Authorities can also include database object permissions. For example, a user with PROFILE authority can perform application profiling and database tracing tasks, which involves using system tables and system procedures that are not available to other users (other than users with DBA authority).
BACKUP authority
DBA authority
PROFILE authority
READCLIENTFILE authority
READFILE authority
REMOTE DBA authority
RESOURCE authority
VALIDATE authority
WRITECLIENTFILE authority
Granting authority
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |