Permissions on columns: in todo list??
Hi,
Will PostgreSQL be able to limit access on colums as well as tables?
Say we have a table foo having columns a,b,c.
GRANT UPDATE ON foo(a) to devrim;
Will that be possible as it is on Oracle?
Best regards,
--
Devrim GUNDUZ
devrim@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
devrimg@tr.net
Web : http://devrim.oper.metu.edu.tr
------------------------------------------------------------------
Use views instead and then set the permissions on the view
Darren Ferguson
On Fri, 12 Apr 2002, Devrim GUNDUZ wrote:
Show quoted text
Hi,
Will PostgreSQL be able to limit access on colums as well as tables?
Say we have a table foo having columns a,b,c.
GRANT UPDATE ON foo(a) to devrim;Will that be possible as it is on Oracle?
Best regards,
--
Devrim GUNDUZ
devrim@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
devrimg@tr.netWeb : http://devrim.oper.metu.edu.tr
---------------------------------------------------------------------------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)