CREATE TABLE problems: Insufficient privileges.

From SQLZOO
Jump to: navigation, search

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