Hi
I am doing some tests on pg732 and one of the tasks is to build a security mechanism for db users.
I created a database and created 3 schemas in it with authorization on schemas to 3 different users 1 for each schema, then created a group with 3 users (which are different ones like they are not the owner of any schemas) and issued a grant statment for all privileges on the databse to the group, but when I try to query any table as any of the users in the group, it says permission denied.
Please help with that.
Thanks for your time.
Brenda
I am doing some tests on pg732 and one of the tasks is to build a security mechanism for db users.
I created a database and created 3 schemas in it with authorization on schemas to 3 different users 1 for each schema, then created a group with 3 users (which are different ones like they are not the owner of any schemas) and issued a grant statment for all privileges on the databse to the group, but when I try to query any table as any of the users in the group, it says permission denied.
Please help with that.
Thanks for your time.
Brenda