RE: Limiting user connections with DBA Studio

[Mercadante, Thomas F]

Title: RE: Database Verification

Rao,

 

why?  why prevent them from using a tool?

 

do they have privs to do anything?  if so, then you have bigger problems. 

 

the tool is never the issue.  the issue is what database account they are using to connect with.  if they have privs to change objects, then the tool does not matter - they can learn to do it using sqlplus.

 

take away dba privs from them, or change the password.  and give them a developers account.

 

hope this helps.

 

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject: Limiting user connections with DBA Studio

Some of our users installed OEM on their local PC's.  They connect to the database through DBA Studio.

 

Is there any way to prevent DBA Studio connections to the server?  I am thinking of using on_logon trigger but no clue how to catch the connection.

 

Any suggestions?

 

Rao