Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Connection to Oracle from SAS application
<uthra.subramanian_at_gmail.com> wrote in message
news:1140808615.855349.199890_at_v46g2000cwv.googlegroups.com...
> Hello,
> Currently we have 2 databases(one is production and other is
> development). Both are on different servers. And one user have
> userid/pwd for both databases. But we are trying to connect to oracle
> thru SAS application 9 version. The idea is to block access to
> production box via SAS application. How is it possible? Please help
> us. Also though we have 2 tnsnames.ora file which runs in the
> background, since the user has access to both databases, the production
> box is not controlled for access.
> SAS connection process is opened like a Notepad, hence if u type the
> userid/dpwd it gets connected immediately. So, we are trying to see
> whether at the database level it could be blocked when another
> application like SAS is requesting for logon on production box.
>
> Your reply will be greatly appreciated.
>
> Thanks
>
Use a different password for development and production :-) What do you mean with "2 tnsnames.ora file which runs in the background" ? Received on Fri Feb 24 2006 - 13:30:56 CST