Re: A Question about Installing Oracle for Clinet?

For the 32-bit Client software you can move the entire C:/ORAWIN95 directory to a LAN drive. Remove the SQL*Plus executable from the /BIN directory. Use the Registry Export function to export the settings in HK_LOCAL_MACHINE/SOFTWARE/ORACLE. To install the software on a client machine:

1. Map a Network drive to the ORAWIN95.
2. Run the .REG file that contains the exported registry settings.
3. Include the ORAWIN95/BIN directory in the PATH

Note that preventing your users from accessing the database outside of your application is a non-trivial task. The best solution is to use role-based security, and have your application issue a "SET ROLE" command in order to activate the permissions.

Violin wrote in message <35bbee7d.11878251_at_172.16.7.252>...
>*****Need Help!*****
>Hello,
>Our company has a new application of Oracle7.3 .
>Lately,we want to install AP to some client PC.
>But I have a problem about installing Oracle for Windows 95.
>In common way,I will choose to install Oracle7 Clinet Software for
>Windows95,step by step completely install oracle for client,
>and then I can see Oracle for Windows95 group and the *.exe
>(Like SQL Net Easy Configuration,SQL Plus 3.3,ODBC
>administrator....etc.)
>But I install in this way,users could change the value in tnsnames.ora
>through SQL Net easy configuration,
>or connect to database by SQL Plus 3.3 (not only from my AP)
>
>We hope the client PC be more simple.
>Users couln't see the oracle for win95 group and its *.exe path,
>but still could connect to database.
>
>I think maybe I need to copy some kinds of files(like *.dll,
>or nls files) to specified path(like c:\windows\system,
>c:\orawin)
>Could anyone give me the file list for copy what files to what path in
>client?
>(I could edit the tnsnames.ora,and I don't have to connect database
> through ODBC )
>
>Thanks for your help!
>Please Cc to :violin.hsiao_at_mail.pouchen.com.tw,Thanks!
Received on Tue Jul 28 1998 - 13:29:18 CDT