REVOKE CREATE Statement

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

Syntax

REVOKE CREATE ON dbspace-name 
FROM 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 – revokes the CREATE privilege on dbspace DspHist from user Smith.
```
REVOKE CREATE ON DspHist FROM Smith
```
Example 2 – revokes the CREATE permission on dbspace DspHist from user ID fionat from the database.
```
REVOKE CREATE ON DspHist FROM fionat 
```

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Requires the MANAGE ANY DBSPACE system privilege.

Parent topic: SQL Statements

Related reference

GRANT CREATE Statement

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