Re: Need good idea

"Vlad Olevsky" <leonid4142_at_yahoo.com> schrieb im Newsbeitrag news:50540181.0505030658.64f68390_at_posting.google.com...
> Obviously such approach is very ineffective, the alternative is to
> create trigger on update event and then execute stored procedure which
> will re-calculate and update the hash value. The problem with this
> approach is that end user could then change the date in the tables and
> then run this store procedure to adjust hash value.
>
> We are looking for some solution that could speed up the hash value
> updating without allowing authorized user to do it
As Frank pointed out, try to create a trigger which calls a function. Let the function run with the grants of the caller and give only authorized callers the exec grant of the function.

Greetings!
Volker Received on Tue May 03 2005 - 10:35:45 CDT