On Friday 01 December 2006 06:03 am, Ezequias Rodrigues da Rocha wrote:
>
> 2006/11/30, imad <[EMAIL PROTECTED]>:
> > You did not grant access privileges to schema.
> > Also GRANT administrators on the base schema as you did for the table.
> >
> > --Imad
> > www.EnterpriseDB.com
> >
> > On 12/1/06,
Schema grants
CREATE SCHEMA base
AUTHORIZATION root;
GRANT ALL ON SCHEMA base TO root;
GRANT USAGE ON SCHEMA base TO administrators;
Table grants
GRANT ALL ON TABLE base."local" TO root;
GRANT SELECT, UPDATE, INSERT ON TABLE base."local" TO administrators;
Still the same proble
You did not grant access privileges to schema.
Also GRANT administrators on the base schema as you did for the table.
--Imad
www.EnterpriseDB.com
On 12/1/06, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:
Hi list,
I am having problem with grants and users on PostgreSQL.
I am using pg
Hi list,
I am having problem with grants and users on PostgreSQL.
I am using pgAdmin to connect like other user to test my permissions.
As the owner of the database I have criated two roles:
administrators (cannot connect)
ezequias (can connect)
I give permissions to a table I have:
GRANT SEL
