CREATE TABLE problems: Insufficient privileges.

From SQLZOO
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

CREATE TABLE problems: Insufficient privileges.

schema:scott

The user account must be set up to permit tables to be created. Usually the database administrator must grant such permissions.

GRANT CREATE ON d_db TO scott
GRANT RESOURCE TO scott