REVOKE CREATE Statement

Removes CREATE privileges on the specified dbspace from the specified user IDs.

Quick Links:

Syntax

REVOKE CREATE ON dbspace-name 
   FROM userID [,...]

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

Example 1 – revokes the CREATE privilege on dbspace DspHist from user Smith:
```
REVOKE CREATE ON DspHist FROM Smith
```
Example 2 – revokes the CREATE privilege on dbspace DspHist from user ID fionat from the database:
```
REVOKE CREATE ON DspHist FROM fionat
```

ANSI SQL–Compliance level: Transact-SQL extension.

Requires the MANAGE ANY DBSPACE system privilege.