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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Reference » SQL statements » SQL statements

 

GRANT statement

Grant roles and privileges to users and roles.

Note

The GRANT syntax related to authorities, permissions, and groups used in pre-16.0 versions of the software is still supported but deprecated. To review that syntax, see GRANT statement (authorities and groups) (deprecated).

To review the SQL Anywhere 12.0.1 GRANT statement syntax for comparison, see [external link] http://dcx.sybase.com/index.html#1201/en/dbreference/grant-statement.html.

 Syntax: Grant system roles
 Syntax: Grant user-defined roles
 Syntax: Grant compatibility roles
 Syntax: Grant system privileges
 Syntax: Grant object-level privileges
 Syntax: Grant the SET USER system privilege
 Syntax: Grant the CHANGE PASSWORD system privilege
 Parameters
 Remarks
 Privileges
 Side effects
 Standards and compatibility
 Example
 See also