Re: permission rejected - Mailing list pgsql-novice

From A.Bhuvaneswaran
Subject Re: permission rejected
Date
Msg-id Pine.LNX.4.44.0304101606430.1046-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to permission rejected  ("paul butler" <paul@entropia.co.uk>)
List pgsql-novice
> 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


pgsql-novice by date:

Previous
From: "John D. Tiedeman"
Date:
Subject: Borland dbExpress in Kylix 3 (Delphi for Linux)
Next
From: Tim Ellis
Date:
Subject: Re: [ADMIN] PLEASE HELP ME URGENT about choosing only the ones