You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
21 lines
718 B
Plaintext
21 lines
718 B
Plaintext
-- Grant all permissions on database
|
|
GRANT ALL PRIVILEGES ON DATABASE <db_name> TO <user_name>;
|
|
|
|
-- Grant connection permissions on database
|
|
GRANT CONNECT ON DATABASE <db_name> TO <user_name>;
|
|
|
|
-- Grant permissions on schema
|
|
GRANT USAGE ON SCHEMA public TO <user_name>;
|
|
|
|
-- Grant permissions to functions
|
|
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA public TO <user_name>;
|
|
|
|
-- Grant permissions to select, update, insert, delete, on a all tables
|
|
GRANT SELECT, UPDATE, INSERT ON ALL TABLES IN SCHEMA public TO <user_name>;
|
|
|
|
-- Grant permissions, on a table
|
|
GRANT SELECT, UPDATE, INSERT ON <table_name> TO <user_name>;
|
|
|
|
-- Grant permissions, to select, on a table
|
|
GRANT SELECT ON ALL TABLES IN SCHEMA public TO <user_name>;
|