Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zigzooloo
Starting Member
1 Post |
 Posted - 2004-11-25 : 01:35:10
|
| is there any way to trap or get notified of select statementsie can we do anything like trigger regarding select stmts. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-25 : 02:27:58
|
quote:
Originally posted by zigzooloo
is there any way to trap or get notified of select statementsie can we do anything like trigger regarding select stmts.
can i ask why do you need this type of security notification? if they'r not allowed to do select, then don't provide permissions.triggers only handle update,delete,insertyou can check sysprocesses for selects, problem is if the select is within sprocs and functions.--------------------keeping it simple... |
 |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2004-11-25 : 06:28:27
|
| The best way to handle this kind of security requirements is to encapsulate everything in stored procedures which log all calls, and not permit the users to access tables directly.If you want to capture all select statements, you will have to use the profiler (it can be set up to log to a table). However, the profiler will always use some system resources. |
|
|
|
|
|
|
trap select