Re: GRANT question

Hi Tom,
thank yor answer.

>Read the error message: this is not a lack-of-permissions problem.
You are right, I just meant that perhaps it needs some other settings, e.g.
set search_path or similar ... Sorry for that...

Regarding the search_path it is the same in both cases:

# show search_path;
 search_path
--------------
 $user,public
(1 row)

What else could cause this problem?

-- csaba


-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Saturday, November 26, 2005 5:29 PM
To: Együd Csaba
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] GRANT question

=?iso-8859-2?Q?Egy=FCd_Csaba?= <csegyud@vnet.hu> writes:
> # select edenproc_usesysid('probauser');
> ERROR:  function edenproc_usesysid(text) does not exist
                                           ^^^^^^^^^^^^^^


I'd wonder whether the two users have the same schema search path...

            regards, tom lane

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.8/183 - Release Date: 2005.11.25.