Security Policies for Tables & Views

[MarkP]

Hi Marco,

Would you consider adding to your enhancement list, please, a request for the support of (FGAC) security policies on tables and views?

For me, as a start, it would be enough to allow security policies to be edited, and to list them against their tables and views in the

Object Browser,

Object Viewer, and

View SQL.

The last is particularly important to us, as policies are dropped in the same way as triggers are when their base table or view is recreated.

Best Regards, Mark.

 

[joseayuso]

It's very interesting, at least, it could be wonderfull if your program could show a warning when a view with tiggers is going to be recompiled.

 

[Marco Kalter]

I have added this to the list of enhancement requests. Note that fact that triggers are dropped when using a "create or replace view" statement is actually an Oracle bug.

------------------
Marco Kalter
Allround Automations

 

[MarkP]

Thank you, Marco, and also for telling me about the trigger bug. I had long accepted it as an unhelpful Oracle feature.

Best Regards, Mark.