Hi

If you write anything such as a audit record when they log in, you could use
a trigger to raiserror. It would not be a very elegant solution though!


John

"James" <jbrake@aeci.org> wrote in message
news:1103312862.596986.208700@z14g2000cwz.googlegr oups.com...
> Thanks for your reply.
>
> If I had access to client code, I'd probably use an application role.
> But, I do not.
>
> The application gives each user read/write access to all tables
> regardless of application security.
>
> I was thinking of checking at login time whether the accessed the
> database from the application or not.
>
> James
>