Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can SYS connect without as sysdba
I totally agree. Their setup routine creates some views against some
v$/dba_ views (I know which ones they want access to. None of those I'm too
worried about.) and then grants permissions on those newly created views to
certain users. Once that's done, sys is out off the picture.
-- Terry Dykstra Canadian Forest Oil Ltd. "TurkBear" <john.greco_at_dot.state.mn.us> wrote in message news:nsoeev0rtll0pekk14ndhhag7fek94i7fl_at_4ax.com...Received on Wed Jun 11 2003 - 13:00:38 CDT
>
> More importantly, why does this 3rd party app need to connect as SYS ?
> That login should be used very sparingly...
>
>
>
> "Terry Dykstra" <dontreply_tddykstra_at_forestoil.ca> wrote:
>
> >Never mind. I found the answer. By setting O7_DICTIONARY_ACCESSIBILITY
=
> >True, you can workaround the requirement for 'as sysdba'.
>
>
>
> ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
News==----
> http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000
Newsgroups
> ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption
=---