CREATE TABLE problems: Insufficient privileges.

From SQLZoo
Jump to navigation Jump to 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
DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects