| From: | nikhil raj <nikhilraj474(at)gmail(dot)com> |
|---|---|
| To: | pgsql-jobs(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)com, pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Roles and security |
| Date: | 2017-11-25 20:03:53 |
| Message-ID: | CAG1ps1xNAQVEWp6vs0bKtAxkK+Ut1V+GLPHHuEQM9j_uhyWbcQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | nikhil raj | 2017-11-25 20:13:22 | A particular database to move to other drive |
| Previous Message | Sven R. Kunze | 2017-11-25 20:00:56 | Re: update field in jsonb |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | nikhil raj | 2017-11-25 20:13:22 | A particular database to move to other drive |
| Previous Message | Craig H | 2017-11-24 17:08:10 | macOS ownership and premissions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2017-11-25 23:15:03 | Re: Roles and security |
| Previous Message | Emi | 2017-11-24 14:47:01 | Re: psql -c "\copy table to test.csv with CSV" - french character is wrong |