Re: permission rejected

Date sent: Thu, 10 Apr 2003 16:17:49 +0530 (IST)
From: "A.Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com>
To: paul butler <paul(at)entropia(dot)co(dot)uk>
Copies to: pgsql-novice(at)postgresql(dot)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