end-users should not have application owner passwords...that's your REAL
problem

-----Original Message-----
From: [Email Address Removed] Thursday, May 31, 2001 3:19 PM
To: LazyDBA.com Discussion
Subject: RE: How to Restrict Access to Sql Plus?



I find it ridiculously easy to open up excel or access and set up a ODBC
connection to the database using a basic user account, and they have free
reign on all the tables owned by the application owner of our ERP
application. I don't know if you know of any way to restrict this access,
other than removing ODBC drivers in Microsoft Office for all the end
users... Removing rights in Oracle from the users would limit their ability
to run the application correctly.


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

*** CONFIDENTIALITY NOTICE ***
Privileged/Confidential Information may be contained in this message and/or
its attachments. This message and its attachments are intended only for use
by the individual(s) listed as the recipient(s). If you are not one of the
intended recipient(s), or responsible for delivery of the message to such
person, you are hereby notified that any disclosure, copying, distribution,
or the taking of any action in reliance on the contents of this information
is strictly prohibited. If you have received this message in error, please
notify the sender by return email and destroy all copies of the email.
Opinions, conclusions and other information in this message that do not
relate to official company business shall be understood as neither given nor
endorsed by the company.
Oracle LazyDBA home page