Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sun-barr!lll-winken!unixhub!slacvm!ian From: IAN@SLACVM.SLAC.STANFORD.EDU Newsgroups: comp.databases Subject: Re: Using auto-login feature of Oracle Message-ID: <90346.182530IAN@SLACVM.SLAC.STANFORD.EDU> Date: 13 Dec 90 02:25:30 GMT References: <911@attc.UUCP> <90346.150757IAN@SLACVM.SLAC.STANFORD.EDU> Organization: Stanford Linear Accelerator Center Lines: 15 In article 90246.15077 I showed away of of logging on to oracle on a remote database from a C program. The user will not know that they are in Oracle. What I forgot to mention is that explicit logins are only required if you want to change information on the remote database. Granting of "select" can be done through database links and synonyms. Then when I'm logged on to my local ops$ account I can access data on the remote machine. The database link does the connection to the remote database, the user need not know what is happening Ian MacGregor [Stanford Lnear Accelerator Center These opinions are mine, and are not necessarily those of The United States Department Of Energy nor Stanford University. They shall not be used for promotional nor advertising purposes]