Reply from bali.sanjay on Jun 25 at 2:06 AM Hi, You can make an entry in tnsnames file to restrict it.
| | | ---------------Original Message--------------- From: iudith mentzel Sent: Monday, June 25, 2012 1:16 AM Subject: Restrict Machine to Login Database Hello, If you want to implement this using triggers, then you can create an AFTER LOGON trigger in which the following select statement will give you the current client machine: select machine from v$session where audsid = sys_context('USERENV', 'SESSIONID') / Then make the trigger to fail if the machine is the one whose access you want to deny. Best regards, Iudith | | Reply to this email to post your response. __.____._ | _.____.__ |
No comments:
Post a Comment