[Postgres] Manage roles

manage-roles.sql

----------------------------------
-- Managing roles in PostgreSQL --
----------------------------------
 
-- Create --
CREATE ROLE name WITH PASSWORD 'd94jsfsd' LOGIN;
 
-- Grant privileges to database --
GRANT ALL PRIVILEGES ON DATABASE database_name TO name;

-- Grant privileges to table --
GRANT ALL PRIVILEGES ON TABLE users TO name;
 
-- Revoke privileges --
DROP OWNED BY name;
 
-- Modify --
ALTER ROLE name WITH login;
 
-- Delete --
DROP ROLE name;