Date sent: Thu, 10 Apr 2003 16:17:49 +0530 (IST)
From: "A.Bhuvaneswaran" <bhuvansql@myrealbox.com>
To: paul butler <paul@entropia.co.uk>
Copies to: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] permission rejected
Thanks very much,
This limitation is not clear from anything in the docs and a view
doesn't really solve this problem. But its no big problem.
Cheers
Paul Butler
> > mfx=# GRANT SELECT ON employee(eid,forename,rights) TO
> > GROUP accessor;
>
> Currently, to grant privileges to only few columns, you must create a view
> having the desired columns and then grant privileges to that view.
>
> # create view employee_view as select eid, forename, rights from employee;
> # grant select on employee_view to group accessor;
>
> regards,
> bhuvaneswaran
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster