Help or Bug?
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.
Show quoted text
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Cl�udia Morgado" <claudia.morgado@widesoft.com.br>
Cc: <pgsql-general@postgresql.org>; "Carla Mello"
<carla.mello@widesoft.com.br>
Sent: Saturday, October 18, 2003 12:57 AM
Subject: Re: [GENERAL] Help or Bug?=?iso-8859-1?Q?Cl=E1udia_Morgado?= <claudia.morgado@widesoft.com.br>
writes:
CREATE SCHEMA wlog_data AUTHORIZATION wlog_data;
...
5=BA) Now We try to create the foreing key :
ERROR: wlog_data: permission deniedI 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
On Monday 20 October 2003 16:19, Cláudia Morgado wrote:
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?
SELECT * FROM pg_namespace ;
For tables, I'd use \dp in psql.
--
Richard Huxton
Archonet Ltd