Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: What privilege allows DBA's to execute query?
Calvin Crumrine <Calvin_Crumrine_at_dced.state.ak.us> wrote in message
news:38EA214F.126D0944_at_dced.state.ak.us...
> We have an application (Forms 6) that issues the seemingly simple query
> shown below that only DBA's can successfully execute. All other users
> receive the messages ORA-00604 (Error occurred at recursive SQL Level 1)
> and ORA-01000 (Maximum open cursors exceeded).
>
> SELECT ROWID,FIELD_1,FIELD_2,...FIELD_40
> FROM USER_VIEW WHERE (FIELD_1=:1)
>
> All users have Select privileges on the view as well as on the
> underlying tables, and all users, including DBAs, use the same profile.
> Since it works for DBA's I don't think it's the Open_cursors parm in
> INIT.ORA, unless some DBA privilege overrides that, but I can't figure
> out what privilege (or combination of privileges) DBA's have that lets
> them execute this. Any ideas?
>
> Thanks.
>
>
select any table privilege
(this is granted to the DBA role)
Hth,
Sybrand Bakker, Oracle DBA Received on Tue Apr 04 2000 - 13:12:43 CDT