GRANT question

From: Együd Csaba <csegyud(at)vnet(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: GRANT question
Date: 2005-11-26 14:01:22
Message-ID: 0IQK005BJEWK1610@invitel.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
As a superuser I created a normal user:

CREATE USER probauser NOCREATEDB NOCREATEUSER;
ALTER GROUP eden_users ADD USER probauser;

a function:

CREATE OR REPLACE FUNCTION edenproc_usesysid(text)
RETURNS int4 AS .........
-- Note that the owner of this function is the superuser.

I added the EXECUTE grant for a function to the probauser:

GRANT EXECUTE ON FUNCTION edenproc_usesysid(text) TO probauser;

And then tried to run the function:

# select edenproc_usesysid('probauser');
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.

Certainly as the superuser I can run the function... What's missing more???

Thank you,
-- Csaba Együd

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2005-11-26 14:01:31 Re: "invalid page header in block 597621
Previous Message Együd Csaba (Freemail) 2005-11-26 13:50:29 Re: Syntax Error in COPY - worked around