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 [,...]>

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.
SAP Database products–the security model is different in SAP ASE and SAP IQ, so other syntaxes differ.

Permissions

Requires the MANAGE ANY DBSPACE system privilege.