Home > IT Answers > SQL Server > Writing a hidden trigger against a SQL table
SQL Server Ask the Experts
2,585 pts.
 Writing a hidden trigger against a SQL table
SQL Server tables, Triggers
How do I write a hidden trigger against a SQL table?

Software/Hardware used:
ASKED: December 10, 2008  7:48 PM
UPDATED: December 13, 2008  2:27 AM
RELATED QUESTIONS
Answer Wiki:
Who are you trying to hide the trigger from? Assuming that you are trying to hide the trigger from the DBA you can't. Users who are members of the sysadmin fixed server role can see all the objects on the server. People who aren't sysadmin or dbo of the database can not see objects which they don't have access to.
Last Wiki Answer Submitted:  December 11, 2008  3:56 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

OK
Why would you want to HIDE a trigger?

Besides the fact that you can not hide it from “Administrators”, WHY?

MIS

MurrayInfoSys
 940 pts.