Skip to content

Instantly share code, notes, and snippets.

@muhammad-asn

muhammad-asn/postgres-grant-permission.txt

Last active June 15, 2024 05:58
Show Gist options
  • Save muhammad-asn/c206b976ef11aa69c9f599a531793ff5 to your computer and use it in GitHub Desktop.
Save muhammad-asn/c206b976ef11aa69c9f599a531793ff5 to your computer and use it in GitHub Desktop.
Download ZIP
Grant All Permission to Database User
Raw
postgres-grant-permission.txt
CREATE USER dev WITH PASSWORD 'hiiiiiiiiii';
ALTER DEFAULT PRIVILEGES
IN SCHEMA public
GRANT ALL PRIVILEGES ON TABLES TO dev;
GRANT CONNECT ON DATABASE database_name TO dev;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO dev;
GRANT ALL PRIVILEGES ON DATABASE database_name TO dev;
GRANT ALL ON SCHEMA public TO dev;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment