Grant Issues with groups - Mailing list pgsql-general

From UMPA Development
Subject Grant Issues with groups
Date
Msg-id 6.0.3.0.2.20040908123810.01c67ec0@pop.umpa-us.com
Whole thread Raw
List pgsql-general
Hello all,

I have setup 2 groups on a database:
admin
users
I have granted all on testing to admin and tried to grant select on testing
to users;
If I do a \d as an admin I see the schema if i do it as user I see nothing..
If i select * from testing i see everything in the table as a admin but if
i do the same thing as a member of users i get an error that nothing
exists... what am i missing?

If is set the users group to full access it is fine... how do I limit the
access?



pgsql-general by date:

Previous
From: mike
Date:
Subject: Re: SQL query - single text value from group by
Next
From: Jean-Luc Lachance
Date:
Subject: Re: 'order by' in an insert into command