t: Friday, December 01, 2006 7:04 AM
To: imad
Cc: Pgadmin-Support; pgsql-sql@postgresql.org
Subject: Re: [pgadmin-support] [SQL] Grants
Schema grants
CREATE SCHEMA base
AUTHORIZATION root;
GRANT ALL ON SCHEMA base TO root;
GRANT USAGE ON SCHEMA base TO administrators;
Table grants
hat should fix the problem.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ezequias
Rodrigues da Rocha
Sent: Friday, December 01, 2006 7:04 AM
To: imad
Cc: Pgadmin-Support; pgsql-sql@postgresql.org
Subject: Re: [pgadmin-support] [SQL] Grants
Schema gra
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
