[Info-Ingres] security_alarms on views

#1

Hi All,

Is there any good reason why I can't install a security_alarm on a view?

It came as quite a surprise to me that this is not possible.
Eg.
create view x as select * from y;
E_PS04D1 'x' is a view. Security alarms may not be created/dropped on a view.

If I create the security alarm on the base tables of the view, I won't get an alarm if the user accesses the view.

Martin Bowes

#2

On Oct 13, 12:39*pm, Martin Bowes <martin.bo... (AT) ctsu (DOT) ox.ac.uk> wrote:

Quote:

Hi All,

Is there any good reason why I can't install a security_alarm on a view?

It came as quite a surprise to me that this is not possible.
Eg.
create view x as select * from y;
E_PS04D1 'x' is a view. Security alarms may not be created/dropped on a *view.

If I create the security alarm on the base tables of the view, I won't get an alarm if the user accesses the view.

Martin Bowes

Just a wild guess, would it require a materialized view for it to work?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[Info-Ingres] security_alarms on views

comp.databases.ingres comp.databases.ingres

[Info-Ingres] security_alarms on views - 10-13-2010 , 04:39 AM

Re: security_alarms on views - 10-18-2010 , 02:48 AM