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?
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
