Re: Oracle Applications DBA question

andyho99_at_yahoo.com (Andrew) wrote in message news:<8882aa3c.0409031549.3dd1a9d_at_posting.google.com>...
> Is there any guidelines whether end users allowed to use sql*plus or
> similar tools to query database. We use Oracle Applicatons 11i. End
> users could use Discoverer to create reports and it use same security
> as OA. If end users want to use sql*plus, we need to set up roles or
> something like that to limit their access. I'm just curious what other
> shop do. Should we allow users to use sql*plus? Thanks.

At one company I worked for we allowed certain users access to SQL*Plus but we had them trained in SQL. At one point we had the data they needed replicated over to another non production database once a day. From time to time someone would write a Cartesian or come up with strange data. But we had the time to sit down with them and provide extra training in SQL.

One of the other issues is training on how to format the data and get it into a spool file so it can be imported into Excel or Access.

---
Brad
http://wowak.com