grant all privileges to role in postgresql code example Example: postgresql grant all privileges on database GRANT ALL PRIVILEGES ON dbname TO username;