Subject RE: [firebird-support] Database security and create permission workaround?
Author Steffen Heil
Hi

> > Couldn't we simply create a trigger for RDB$SOMETHING to watch for
> > create modifications and rollback if that user doesn't have
> sufficient
> > rights in our system?
> > Or aren't trigges allowed on RDB$... tables?
>
> Triggers are allowed, but user defined triggers on system
> tables are dropped when the database is backed up and
> restored by gbak.

That means, if we care about that when doing in-place restores (which should
be rare anyway), we CAN get CREATE permissions in place, right?
Has anyone ever tried?

BTW, why are they dropped? Feature request: upcoming versions of gbak
*should* restore those, too.

Regards,
Steffen


[Non-text portions of this message have been removed]