Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Connection to Oracle from SAS application

Re: Connection to Oracle from SAS application

From: Matthias Hoys <anti_at_spam.com>
Date: Fri, 24 Feb 2006 20:30:56 +0100
Message-ID: <43ff5ef1$0$16885$ba620e4c@news.skynet.be>

<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US