Re: GRANT question

Tom, I see your point and you are right.

Michael, it seems if no functions were in my database...

When I created the moson.gdb database I didn't create any additional
schemas. I simply reloaded the dump - I think into the public. Thats all.
In PgAdmin the (all my) functions can be seen in the public schema (logging
in as any user). I don't really understand. What do I do wrong?

postgres(at)saurus:~> psql -U eden_admin moson.gdb
Password:
moson.gdb=# select edenproc_usesysid('probauser'::text) as usesyid;
usesyid
---------
118
(1 row)

moson.gdb=# show search_path;
search_path
--------------
$user,public
(1 row)

moson.gdb=# \df edenproc_usesysid
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------------+------------------+---------------------
public | edenproc_usesysid | integer | text
(1 row)

moson.gdb=# SELECT current_database();
current_database
------------------
moson.gdb
(1 row)

moson.gdb=# \q

postgres(at)saurus:~> psql -U probauser moson.gdb

moson.gdb=> select edenproc_usesysid('probauser'::text) as usesyid;
ERROR: function edenproc_usesysid(text) does not exist
HINT: No function matches the given name and argument types. You may need
to add explicit type casts.

moson.gdb=> \df edenproc_usesysid
List of functions
Schema | Name | Result data type | Argument data types
--------+------+------------------+---------------------
(0 rows)

moson.gdb=> \df eden*
List of functions
Schema | Name | Result data type | Argument data types
--------+------+------------------+---------------------
(0 rows)

moson.gdb=> SELECT current_database();
current_database
------------------
moson.gdb
(1 row)

-----Original Message-----
From: Michael Fuhr [mailto:mike(at)fuhr(dot)org]
Sent: Saturday, November 26, 2005 6:28 PM
To: Együd Csaba
Cc: 'Tom Lane'; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] GRANT question

On Sat, Nov 26, 2005 at 06:13:21PM +0100, Egyd Csaba wrote:
> Regarding the search_path it is the same in both cases:
>
> # show search_path;
> search_path
> --------------
> $user,public
> (1 row)

For different users, the above represents *different* search paths because
$user is expanded to the user name if a schema exists with that name.

What does "\df edenproc_usesysid" show in psql? If it shows nothing then
try wildcarding the name, like "\df *eden*". If it still shows nothing, are
you sure you're connecting to the same database?
What does "SELECT current_database();" show for each user?

--
Michael Fuhr

--
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.