Re: Roles and security

2017-11-26 Thread Laurenz Albe
nikhil raj wrote: > 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

Re: Roles and security

2017-11-25 Thread John R Pierce
On 11/25/2017 12:03 PM, nikhil raj wrote:  check the roles of user I want to give user roles only select, insert, update, execute and create database to all users Permission those permissions can be assigned on a table by table basis, except create database, thats a special permission.    if

Roles and security

2017-11-25 Thread nikhil raj
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 databa