GRANT CREATE Statement

Grants CREATE privilege on a specified dbspace to the specified users and roles.

Syntax

GRANT CREATE
  ON dbspace_name
  TO userID [,...]

Parameters

userID – must be the name of an existing user or role that has a login password. Separate multiple userIDs with commas.

Examples

Example 1 – grants users Lawrence and Swift CREATE privilege on dbspace DspHist.
```
GRANT CREATE ON DspHist
TO LAWRENCE, SWIFT
```
Example 2 – grants CREATE privilege on dbspace DspHist to users Fiona and Ciaran.
```
GRANT CREATE ON DspHist TO Fiona, Ciaran
```

Standards

SQL – other syntaxes are vendor extensions to ISO/ANSI SQL grammar.
Sybase – the security model is different in Adaptive Server Enterprise and SAP Sybase IQ, so other syntaxes differ.

Permissions

Requires the MANAGE ANY DBSPACE system privilege.

Parent topic: SQL Statements

Related reference

REVOKE CREATE Statement

Created May 23, 2013. Send feedback on this help topic to Technical Publications: pubs@sybase.com