| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Gaurav K Srivastav <gauravgkp(at)gmail(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Regarding permissions |
| Date: | 2009-08-21 19:56:08 |
| Message-ID: | 603c8f070908211256q6ad1325dh7ce743c56f52e7c5@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Wed, Aug 19, 2009 at 5:45 AM, Gaurav K Srivastav<gauravgkp(at)gmail(dot)com> wrote:
> HI,
>
> I have a normal user 'abcd' and grant all previliges to this user on the
> database 'pqr'.
> now i am unable to use dblink(text,text).
> while via super user 'postgre' which is the owner of database 'postgre' I
> am able to use dblink(text,text).
> Can you please let me know how to get use of dblink(text,text) in normal
> user databse.
>
> while creating dblink(text,text) I got the error
> ERROR: permission denied for language c
> SQL state: 42501
>
> Please let me know that how to fix it.
This isn't a bug. You might try -general or -novice. I would also
suggest, as I did before, reading the docs for GRANT.
...Robert
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2009-08-21 19:58:37 | Re: When Drop Table or alter Table I need restart service Posgresql - 8.1 ????? |
| Previous Message | Tom Lane | 2009-08-21 18:35:18 | Re: 8.4.0 data loss / HOT-related bug |