Tag Info

New answers tagged

5

I think as a DBA you will inevitably lose the fight to keep hands out of your database. Having said that I think we owe it to our customers to try and provide a product that they can use. There are dangers and pitfalls of even read-only access that any DBA should be aware of: You admitted that you are working with large record counts in your tables. What ...


1

Be happy that your users seem to be going to use SQL to do the analysis, instead of pumping to excel. Make sure you have separated tasks and don't give privs to update the source data. Resource manager is your friend to prevent runaway queries. give them resources that they need, make sure other users don't get pushed out.


1

I think there is no problem, but you need to take care about data. For example, you can grant them privileges to create tables and procedures for their needs in theirs schemas, and privileges to select data from another schemas, but not to grant privileges on insert/update/delete. If they don't have privileges on update and delete data in main tables, ...


0

Maybe you need something like this? create or replace procedure p1 is begin select ... into ... from ... where ...; exception when no_data_found then ... raise_application_error(-20100, 'Something not found'); when others then ... end; create or replace procedure p2 is something_not_found exception; pragma ...


0

This might be over simplifying it, but could you use an IF *some variable* IS NOT NULL block around the call to the extra procedure? As in, "check to see if the variable I just wrote to is null, if not, do more work, if it is, specifically call my custom error package? If you've built your own exception handler (and kudos to you for not falling into the ...


1

There are a variety of approaches you could take. You should pick the one you feel is most suitable for your application. Include no WHEN OTHERS exception handlers and let the raw Oracle errors propagate to your users. Include WHEN OTHERS exception handlers in the top-level blocks. Include WHEN OTHERS exception handlers in all/most blocks The first ...



Top 50 recent answers are included