Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Security Expand / Collapse
Author
Message
Posted Thursday, February 10, 2011 4:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, January 16, 2013 9:49 AM
Points: 35, Visits: 13
Good work.

I have used "SQL making SQL" before in generating audit trail triggers.

Security needs to be addressed as well, by adding grants at the end.

Maybe pull the rights from the underlying table, and/or from the rights on the existing proc (to preserve that when regenerating)






Post #1061852
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse