Roles and security

nikhil raj <[email protected]> Sun, 26 Nov 2017 01:33:53 +0530

Newsgroups	gmane.comp.db.postgresql.novice,gmane.comp.db.postgresql.sql,gmane.comp.db.postgresql.general
Message-ID	<CAG1ps1xNAQVEWp6vs0bKtAxkK+Ut1V+GLPHHuEQM9j_uhyWbcQ@mail.gmail.com>

Hi

I am Nikhil currently working as a MS SQL DBA . Currently my company is
shifting from MS SQL to postgres

 check the roles of user I want to give user roles only select, insert,
update, execute and create database to all users Permission


The users should not have these permission
 drop database , delete table permission


**(Example --like in MS SQL we have like DB_roles-- ddladmin,data
writer,data reader ,etc like these do we have in postgres).***

Thanks