Thread: Grant Issues with groups

Grant Issues with groups

From
UMPA Development
Date:
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?