>
> create view myinst as select * from dblink('dbname=sva4_int1','select
> from inst') as (...);
>
> The view connect not to a remote database. It uses the local database.
> You can read the data from table inst without any restrictions! (Select *
> from myinst ...)
> This problem could a
password, it only knows
encrypted presentation (someone else could know this better).
Regards !
- Original Message -
From: "Kreißl, Karsten" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 22, 2004 11:50 AM
Subject: [HACKERS] User Privileges using dblink
Hello,
we want use dblink to connect several databases in a client/server environment.
Connection from local users to the remote databases should be possible only for
privileged users. We tried a solution with dblink, embedding this command in a view,
like this:
create view inst as select * fr
