To restrict Pl/sql functions

[woojong]

Hi.

I am letting some users use PL/SQL in order to obtain very lage data in Excel format. Problem is, sometimes they make mistakes like querying for the last 3 years which causes a performance problem. Therefore, I wish to know how to restrict functions so that they can only query specific qrys and down load excel file.

I've made reports for that purpose, but users prefer PL/SQL, because of the speed and stability.

Thanks in advance.

 

[William Robertson]

You could look at Resource Profiles and Workload Management .

btw did you mean PL/SQL or PL/SQL Developer ? One is a programming language, the other is a desktop application.