Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL statements » Alphabetical list of SQL statements

GRANT CREATE statement

Allows a user to create database objects in the specified dbspace.

GRANT CREATE ON dbspace-name 
TO userid, ...

When you initialize a database, it contains one database file. This first database file is called the main file. All database objects and all data are placed, by default, in the main file. A dbspace is an additional database file that creates more space for data. A database can be held in up to 13 separate files (the main file and 12 dbspaces). Each table, together with its indexes, must be contained in a single database file. The SQL command CREATE DBSPACE adds a new file to the database.


You must have the MANAGE ANY USER privilege.

Side effects

Automatic commit.

  • ANSI/ISO SQL Standard

    Not in the standard.