Re: More on: trigger access control failure on NEW
Tobias Downer <[email protected]>
| Newsgroups | gmane.comp.db.mckoi |
|---|---|
| Message-ID | <[email protected]> |
It shouldn't work like that. Regular users should be able to create triggers which execute under their own access rights. I will look into it. Thanks, Toby. R.W. Shore wrote: > ... and in fact things work just fine when the admin user is the one that > issues the create-trigger command. It's just that nobody else can > successfully execute a trigger. When a non-admin user issues the > create-trigger command, the trigger gets the access-control violation on > SYS_INFO.NEW, which I assume is the full name of the NEW table. > > You could make an argument that this is a security feature and not a bug, if > fixing is in the too-hard category ;-) > > I didn't try issuing the create-procedure command from the non-admin user > and the create-trigger command from the admin user, so I don't know if that > would work or not. --------------------------------------------------------------- Mckoi SQL Database mailing list http://www.mckoi.com/database/ To unsubscribe, send a message to [email protected]