HELP - Grant

From: Andrew M. Balshem <am_balshem_at_fccc.edu>
Date: 1998/03/10
Message-ID: <3505a3c9.115406806_at_news.services.fccc.edu>#1/1


    We have a user who we've be told to give "insert" and "update where null" privilege. This can be done simply enough in a form but we were wondering if there is anyway to implement this at the database level (something along the lines of:

grant update(fname) where fname is null on table to ops$user; or
grant update(fname) on table where fname is null to ops$user;

neither of which work.)

Any thoughts? Are there database triggers which might accomplish this? Received on Tue Mar 10 1998 - 00:00:00 CET

Original text of this message