Trigger creation by one user against another user's table

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 24 Jul 2003 10:11:08 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703F30847@lnewton.leeds.lfs.co.uk>

Morning Steve,

I'm puzzled as to why you would want to do this, however, as far as I'm aware, you need to grant the 'create any trigger' priv - which you already know about and have reservations about doing, for obvious reasons.

The only other way I can suggest you do this is for USER1 to create the required triggers for USER2.

You wouldn't be wanting USER2 to create triggers 'on the fly' would you ?

Cheers,
Norm.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

Received on Thu Jul 24 2003 - 04:11:08 CDT