GRANT System Privilege Statement

Grants specific system privileges to users or roles, with or without administrative rights.

Quick Links:

Go to Parameters

Go to Examples

Go to Usage

Go to Standards

Go to Permissions

Syntax

GRANT system_privilege_name [, …]  
   TO userID [, …] 
   [ { WITH NO ADMIN | WITH ADMIN [ ONLY ] } OPTION ]

Parameters

(back to top)

Examples

(back to top)

Usage

(back to top)

By default, if no administrative clause is specified in the grant statement, the WITH NO ADMIN OPTION clause is used.

Standards

(back to top)

  • SQL–Other syntaxes are vendor extensions to ISO/ANSI SQL grammar.

  • SAP Sybase Database product–Syntax is supported in Adaptive Server.

Permissions

(back to top)

Requires administrative privilege over the system privilege being granted.
Related reference
CREATE USER Statement
REVOKE System Privilege Statement
REVOKE ROLE Statement
VERIFY_PASSWORD_FUNCTION Option