Database:

GRANT ALL PRIVILEGES ON DATABASE DATABASENAME to USER;

Table:

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO USER;

Id Seq Tables:

GRANT ALL PRIVILEGES  ON ALL SEQUENCES IN SCHEMA public TO USER;

Advertisements