Access rescrictions - Mailing list pgsql-general

From Elmar.Haneke@gmx.de
Subject Access rescrictions
Date
Msg-id A97E85E30@haneke.de
Whole thread Raw
Responses Re: [GENERAL] Access rescrictions
List pgsql-general
Hello,

I'm looking for an solution to restrict the access to show an part of an Table only:
In an customer-database it should be possible to list the bills of an certain customer,
but it should be restricted to generate/summarize a list of all bills.

"SELECT * FROM Bills"  should be restricted
"SELECT * FROM Bills WHERE CustomerID=?" should be allowed for any CustomerID.

Is there an solution to this problem in PostgreSQL?

Elmar

pgsql-general by date:

Previous
From: Adriaan Joubert
Date:
Subject: Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM?
Next
From: postgres@taifun.interface-business.de
Date:
Subject: Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM?