Timeline for DENY insert,update,delete to user (PostgreSQL)
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 16, 2015 at 0:48 | vote | accept | DeviLFisH | ||
| Nov 15, 2015 at 14:30 | answer | added | Craig Ringer | timeline score: 3 | |
| Nov 15, 2015 at 8:39 | history | edited | DeviLFisH | CC BY-SA 3.0 |
added 78 characters in body
|
| Nov 15, 2015 at 7:42 | answer | added | a_vlad | timeline score: 0 | |
| Nov 15, 2015 at 7:00 | comment | added | DeviLFisH |
Maybe i wasn't clear enough. I want user1 to be able to grant everything he wants to everyone except user2. That's why i am trying to use the DENY command.
|
|
| Nov 15, 2015 at 6:49 | comment | added | user1822 |
I think you need to grant each privilege separately. grant select on table1 to user1 with grant option; grant insert,update,delete on table1 to user1;
|
|
| S Nov 15, 2015 at 6:47 | history | edited | user1822 | CC BY-SA 3.0 |
It's Postgres not Postgre
|
| S Nov 15, 2015 at 6:47 | history | suggested | vijayp | CC BY-SA 3.0 |
formatted sql code and removed thanks
|
| Nov 15, 2015 at 6:35 | review | Suggested edits | |||
| S Nov 15, 2015 at 6:47 | |||||
| Nov 15, 2015 at 6:20 | review | First posts | |||
| Nov 15, 2015 at 6:35 | |||||
| Nov 15, 2015 at 6:17 | history | asked | DeviLFisH | CC BY-SA 3.0 |