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 -- 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
