Perfect ! Exactly what I was looking for 'anonymous blocks' Thank you David !
On Nov 16, 12:44 pm, ddf <orat...@msn.com> wrote: > 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- Hide quoted text - > > - Show quoted text - -- 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
