Re: permission rejected

From: "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com>
To: paul butler <paul(at)entropia(dot)co(dot)uk>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: permission rejected
Date: 2003-04-10 10:47:49
Message-ID: Pine.LNX.4.44.0304101616490.1046-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message paul butler 2003-04-10 11:19:38 Re: permission rejected
Previous Message A.Bhuvaneswaran 2003-04-10 10:39:21 Re: permission rejected