GRANT CREATE Statement

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

Quick Links:

Syntax

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

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

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
```

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

Requires the MANAGE ANY DBSPACE system privilege.