-
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
-
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.
-
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.
-
oh..for the benefits of those here...what is that trigger function name ??
ngwh,
Singapore.
-
how about remove his 'CREATE SESSION' right in database b1 ?
-
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 :-)
-
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.
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|