how can restrict user to not connect to database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: how can restrict user to not connect to database

  1. #1
    Join Date
    Aug 2001
    Posts
    56

    Angry

    Hi.
    I have Two Database on one OracleHome at Window Nt server of Oracle8.1.7
    The user using one database a1 , on his machine oracle programer client is installed, now he also know the password and user to conenct second database b1. he has done changes in tnsname.ora file own(client machine). but we don't want that that user should not connect to database b1.

    how we can restrict that only some of user connect database b1.

    Anuj

    [Edited by anuj on 12-01-2001 at 01:35 AM]
    Anuj
    India

  2. #2
    Join Date
    Feb 2001
    Posts
    389
    It is possible if you create two listeners one for each of the database with seperate TNS_ADMIN directory and then
    for database b TNS_ADMIN directory in protocol.ora
    u disallow his IP address

    2) Or if u rin 8.1.x , write a database logon trigger checking
    the user from which IP address is he logging and kick him out.

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by gpsingh
    It is possible if you create two listeners one for each of the database with seperate TNS_ADMIN directory and then
    for database b TNS_ADMIN directory in protocol.ora
    u disallow his IP address

    2) Or if u rin 8.1.x , write a database logon trigger checking
    the user from which IP address is he logging and kick him out.
    I think 2 is a very good solution for you if you are familiar with the new triggers in
    Oracle 8i. If not ask here. There is a very simple function in Oracle which checks the
    IP-address of the user.


  4. #4
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    oh..for the benefits of those here...what is that trigger function name ??
    ngwh,
    Singapore.

  5. #5
    Join Date
    Dec 2000
    Posts
    126
    how about remove his 'CREATE SESSION' right in database b1 ?

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by culonbu
    how about remove his 'CREATE SESSION' right in database b1 ?
    A user who cannot even create a session? I wonder what he could do in the database :-)

  7. #7
    Join Date
    Jan 2000
    Location
    Silver Spring MD USA
    Posts
    105
    Is there a reason why you cannot change the password for the account you don't want this user to access?
    Change the password and don't give him/her the new password.

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by maachan
    Is there a reason why you cannot change the password for the account you don't want this user to access?
    Change the password and don't give him/her the new password.
    Sometimes our facination with the technology surpasses the obvious. Kudos maachan...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  9. #9
    Join Date
    Mar 2001
    Posts
    314
    Good One Jeff

    How about simply locking the account huh??

    -amar

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