Re: Getting Role and Permissions from DB

Hi Thomas:

Thank you very much again for your valuable guidance.

Sorry, I don't understand the last paragraph - Long story short .... Would you mind giving some examples and alert points when we add another piece to the view that might break the upgrade, please?

Thanks a lot,

Thomas Kyte (tkyte_at_us.oracle.com) wrote:

: Long story short: Views are a tool just like stored procedures are and triggers
: are. <Snip>

: <Snip> I've written my own
: views against the base tables in the data dictionary to do things they can't or
: don't (or just perform too slowly). I think twice before doing so cause every
: time you do that, you add another piece that might break when you upgrade --
: they same would be true of your application -- every time you query against the
: base tables, you have linked your application to that schema, if you feel the
: need to change the schema, you have to fix the application. Not too hard if you
: do everything in pl/sql as the dependency mechanism makes it easy to find all of
: the broken code, but if you have a large app where some of the sql lives in the
: application, it can get harder.
Received on Sun Jan 03 1999 - 22:49:28 CST