Reply from iudithm on Jun 25 at 1:15 AM 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
| | | ---------------Original Message--------------- From: oracle oracle Sent: Sunday, June 24, 2012 7:33 PM Subject: Restrict Machine to Login Database Dear Experts...In Oracle 11gR2..do we have any feature so we can restrict database login for a particular machine...i.e. I mean we have a machine xyz and I want that if anybody tries to login DB from this machine, it should not. | | Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today. _.____.__ |
No comments:
Post a Comment