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?