Re: permission rejected

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