Very Computer

Hello!

I'm working on Oracle Server v7.3 on WinNT.
I have some problems, by protection in replication environment.
Let's say we have the next users:
1. INTERNAL     ... Database Administrator ... SYS
2. SYSTEM       ... What kind of user is that exactly?
3. REPADMIN     ... Replication administrator
4. REPSYS       ... Surrogate Replication administrator (system access)
5. WORK_USER    ... Schema owner
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?

Bo?tjan ?tupica  /  Ixtlan Consulting d.o.o.  / EMail:

On 3 Jun 1997 08:22:14 GMT, "Bostjan Stupica"

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.

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

============================================================