You may look at the discover program options. Forms for example allows you
to set "use form privileges" or something to that effect. That way, if I
compile as power user -- the form can do anything the power user could do
even though the person logged in has no authorities (other than connect).
When you execute a proc, you use the proc privs for other actions. If the
problem users should only have access to discover and not be allowed any
other access or be allowed updates you should be able to accomplish the task
using roles as previously suggested.
Agi <agichen_at_my-deja.com> wrote in message
news:7ue6hd$ros$1_at_nnrp1.deja.com...
> Hello,theres,
> Our users usually use discover to retrive data.
> Can I audit the user who uses sql*plus( or other tools like
> Access,Foxpro--via ODBC) to connect db ??
> Or even reject the requests except Discover users ????
>
> Any Idea ??
> Do appreciate for your help !!
> Rgds,
> Agi
>
>
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Oct 18 1999 - 07:04:23 CDT
