On Nov 15, 2:28 pm, tcellr <markb...@gmail.com> wrote: > As a data analyst (former DBA) I am trying to put together Dynamic > Reports. For example, query1 would pull dates needed for reports > query. Query2 would uses these dates as parameters and loop to build > a large multiquery, that user would run later for reports. > > The problem is that I receive "insufficient privileges" when I try to > INSERT, Build or REPLACE, or run Stored Procedures. I can build and > run SELECT statements, and some EXECUTES. This is on a vendors server > who will not give higher privileges. I am somewhat new to PL/SQL, so > I am wondering if there is some direction that I hadn't thought of, to > build somewhat automated reporting. (I cannot save anything on the > server, only have VIEWS) > > On Nov 15, 4:05 pm, ddf <orat...@msn.com> wrote: > > > On Nov 15, 7:11 am, tcellr <markb...@gmail.com> wrote: > > > > Is there a way I can do Dynamic SQL with only low level of > > > privileges? For example, I want Dates from one query to be input to > > > dynamicly built scripts, which others could just run later, with > > > parameters already installed in the Select statements. I do not have > > > privileges to create, update, or run stored procedures. It looks like > > > I can do this in Toad (TDA), but we would prefer to stay with Oracle. > > > Any thoughts? > > > What, exactly, are you trying to do? Please provide examples so we > > can better understand your situation. > > > David Fitzjarrell > >
There is no work-around for insufficient privileges when trying to create stored procedures. You might try writing PL/SQL scripts to do this since anonymous blocks can use privileges granted through a role. David Fitzjarrell -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
