| 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: | Whole Thread | Raw Message | 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.
| 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 |