trying to create a better authentication and authorization for sql server 2000

thanks

I know that triggers on system tables don't work.

anyway..thanks for ur discussion.

thanks

Is it true that sp_grantdbaccess and sp_revokedbaccess wont work in a trigger?.

hi,

i wanted to use trigger as a security component. i.e. use trigger for authentication and authorization.

after catching and verifying the client login information from the profiler i wanted to let...

i was trying to use it for developing a multistage security system(authorization and authentication).(for sql server authentication only)

dear Ninja,

I still have some more problems. Precisely saying i was trying to use that cursors in a trigger. But i have realized it now that one cannot use any...

Dear Ninja,

thank u very much. It is working.

have a nice day.

thanks once again.