Re: Problem by Replication security!!!

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/06/03
Message-ID: <33940d33.13682082@www.sigov.si>#1/1

On 3 Jun 1997 08:22:14 GMT, "Bostjan Stupica" <bostjan.stupica_at_ixtlan.si> wrote:

>I'm working on Oracle Server v7.3 on WinNT.
>I have some problems, by protection in replication environment.
> ..... [SNIP] ....
>Then I have created the following links from DB1 to DB2:
>1. Public database link (without user name and password) owned by SYS
>2. Private user link owned by REPSYS
>3. Private user link owned by READMIN
>4. Private user link owned by WORK_USER
>
>And now the problem ...
>When I connect on DB1 as INTERNAL (SYS) I can't access on DB2, because I
>have only public link without username and PSW. That is OK.
>But when I connect on DB1 as SYSTEM I can access on DB2 ???? That is NOT
>OK!!! How can that be, because the user SYSTEM havo no links?
>
>Any Idea?

Obviously your SYS acounts in both databases have different passwords, while your SYSTEM acounts have not.

If you create db_link without CONNECT TO part of command then then db_link tries to connect to remote db with username/password of local user. If such user exists on remote db and have the same password then connection is succesfull, othervise it is not.

Remember that public db_links are available to all users, so you cant say your user SYSTEM have no links.
>
>Boštjan Štupica / Ixtlan Consulting d.o.o. / EMail:
>bostjan.stupica_at_ixtlan.si
>

Regards,

Jurij Modic                             Republic of Slovenia
tel: +386 61 178 55 14                  Ministry of Finance
fax: +386 61  21 45 84                  Zupanciceva 3

e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000

Received on Tue Jun 03 1997 - 00:00:00 CDT