DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DB Access related Privileges using the IPAddress

  1. #1
    Join Date
    Jul 2007
    Location
    India
    Posts
    21

    DB Access related Privileges using the IPAddress

    Hi..,
    If I want to restrict the Access privileges on IPAddress Wise/OS User Wise in my Network For My database is possible in Oracle
    We require this type of requirement so.., that can any body help me..
    Actually this is possible in MYSQL & SQL Server.

    Thanks in Advance
    Giri K.Y.

  2. #2
    Join Date
    Jan 2007
    Posts
    231
    It is also possible in Oracle, use this

    In sqlnet.ora file add this parameters.

    tcp.validnode_checking = YES
    tcp.excluded_nodes = {list of IP addresses}

    After setting this parameter restart listener.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width