Re: Identifying super users

Thanks! You understood what I meant and this information helps a lot.

My apologies to DA Morgan for my sloppy use of terminology (which is inexcusable) and for not including Oracle version numbers (which I thought was irrelevant within this context).

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<HAKU9.23596$jM5.62538_at_newsfeeds.bigpond.com>...
> <tunity5_at_yahoo.com> wrote in message
> news:32bcd267.0301131002.713015ff_at_posting.google.com...
> > Is there a way to determine whether the current user is a super user
> > (with admin privileges) from within a stored procedure?
> >
> > Thanks!
>
> By Super User, I presume you mean an Oracle User who is able to perform any
> one of the 5 privileged actions (create, startup, shutdown, backup and
> recover)?
>
> For anyone to perform any of those actions, they must have been granted the
> SYSDBA privilege, so it would be relatively easy to check v$pwdfile_users to
> see who is a member.
>
> ...
> ...
>
> Regards
> HJR
Received on Tue Jan 14 2003 - 11:36:35 CST