Revisions to DENY insert,update,delete to user (PostgreSQL)

added 78 characters in body

Source Link

edited Nov 15, 2015 at 8:39

13
1
4

I wonder if Postgres support the DENY command. I search in the documentation but I couldn't find anything about deny.

I have GRANT ALL ON table1 TO user1 WITH GRANT OPTION but I don't want user1 to be able to grant insert/update/delete to user2. (He can do whatever he want with everyone else!!!)

I want to use this command DENY INSERT,UPDATE,DELETE ON table1 TO user2;

Is there any way to accomplish this?

I wonder if Postgres support the DENY command. I search in the documentation but I couldn't find anything about deny.

I have GRANT ALL ON table1 TO user1 WITH GRANT OPTION but I don't want user1 to be able to grant insert/update/delete to user2. (He can do whatever he want with everyone else!!!)

Is there any way to accomplish this?

I wonder if Postgres support the DENY command. I search in the documentation but I couldn't find anything about deny.

I have GRANT ALL ON table1 TO user1 WITH GRANT OPTION but I don't want user1 to be able to grant insert/update/delete to user2. (He can do whatever he want with everyone else!!!)

I want to use this command DENY INSERT,UPDATE,DELETE ON table1 TO user2;

Is there any way to accomplish this?

It's Postgres not Postgre

Source Link

edited Nov 15, 2015 at 6:47

user1822

I wonder if PostgrePostgres support the DENY command. I search in the documentation but iI couldn't find anything about deny.

I have GRANT ALL ON table1 TO user1 WITH GRANT OPTION but iI don't want user1 to be able to grant insert/update/delete to user2. (He can do whatever he want with everyone else!!!)

Is there any way to accomplish this?

I wonder if Postgre support the DENY command. I search in the documentation but i couldn't find anything about deny.

I have GRANT ALL ON table1 TO user1 WITH GRANT OPTION but i don't want user1 to be able to grant insert/update/delete to user2. (He can do whatever he want with everyone else!!!)

Is there any way to accomplish this?

I wonder if Postgres support the DENY command. I search in the documentation but I couldn't find anything about deny.

I have GRANT ALL ON table1 TO user1 WITH GRANT OPTION but I don't want user1 to be able to grant insert/update/delete to user2. (He can do whatever he want with everyone else!!!)

Is there any way to accomplish this?

formatted sql code and removed thanks

Source Link

edit approved Nov 15, 2015 at 6:47

vijayp

2.8k
1
17
20

I wonder if Postgre support the DENYDENY command. I search in the documentation but i couldn't find anything about deny.

I have GRANT ALL ON table1 TO user1 WITH GRANT OPTIONGRANT ALL ON table1 TO user1 WITH GRANT OPTION but i don't want user1 to be able to grant insert/update/delete to user2. (He can do whatever he want with everyone else!!!)

Is there any way to accomplish this?

Thanks!

I wonder if Postgre support the DENY command. I search in the documentation but i couldn't find anything about deny.

I have GRANT ALL ON table1 TO user1 WITH GRANT OPTION but i don't want user1 to be able to grant insert/update/delete to user2. (He can do whatever he want with everyone else!!!)

Is there any way to accomplish this?

Thanks!

I wonder if Postgre support the DENY command. I search in the documentation but i couldn't find anything about deny.

I have GRANT ALL ON table1 TO user1 WITH GRANT OPTION but i don't want user1 to be able to grant insert/update/delete to user2. (He can do whatever he want with everyone else!!!)

Is there any way to accomplish this?

Source Link

asked Nov 15, 2015 at 6:17

DeviLFisH

13
1
4

Loading

Stack Exchange Network

Return to Question