Re: Help or Bug?

From: "Carla Mello" <carla(dot)mello(at)widesoft(dot)com(dot)br>
To: Cláudia Morgado <claudia(dot)morgado(at)widesoft(dot)com(dot)br>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Help or Bug?
Date: 2003-10-20 12:34:43
Message-ID: 00de01c39706$8a97ada0$16011aac@widesoft.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane,

This problem was solved with the suggested permission.

GRANT USAGE ON SCHEMA wlog_data TO wlog_uni;

There is the possibility of us to consult the permission above in the
database?

Thanks very much,
Carla Mello and Cláudia Morgado.

Thanks very much.
We resolve this problem with the permission
----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Cláudia Morgado" <claudia(dot)morgado(at)widesoft(dot)com(dot)br>
Cc: <pgsql-general(at)postgresql(dot)org>; "Carla Mello"
<carla(dot)mello(at)widesoft(dot)com(dot)br>
Sent: Saturday, October 18, 2003 12:57 AM
Subject: Re: [GENERAL] Help or Bug?

> =?iso-8859-1?Q?Cl=E1udia_Morgado?= <claudia(dot)morgado(at)widesoft(dot)com(dot)br>
writes:
> > CREATE SCHEMA wlog_data AUTHORIZATION wlog_data;
> > ...
> > 5=BA) Now We try to create the foreing key :
> > ERROR: wlog_data: permission denied
>
> I think you forgot to grant USAGE on the wlog_data schema to the other
> user. This permission bit doesn't have any equivalent in Oracle AFAIK,
> but it corresponds to execute permission on a Unix directory, if that
> helps you at all...
>
> regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martin Marques 2003-10-20 12:39:00 Re: plpgsql
Previous Message Jeff 2003-10-20 12:09:34 Re: Recomended FS