| Lists: | Postg사설 토토SQL : Postg사설 토토SQL 메일 링리스트 : 2009-08-19 이후 PGSQL-BUGS |
|---|
| From: | Gaurav K Srivastav <gauravgkp(at)gmail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Regarding permissions |
| Date: | 2009-08-19 09:45:05 |
| Message-ID: | bf0617110908190245j21ad2330x29d5ab6098e5ccd4@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg사설 토토SQL : Postg사설 토토SQL 메일 링리스트 : 2009-08-19 이후 PGSQL-BUGS |
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.
Thnx & Rgds
Gaurav Kumar Srivastava
| 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 |
| 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