I know there is a way to do this with tables but I can not remember how I did it for my last job... is there a trigger I can set up for this.. the individual who is doing this is my manager and I suspect that he is altering parts of my code in the stored proc. to hinder me...? can you help...?
--- "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Hi MC > I think, you've got a simple security problem which > you ought to solve with the built-in security > features. > 1. change the database administrator password and > keep it secret. > 2. create the appropiate (required) rights for the > tables > 3. create the rights for the procedures (allow > execute, no more!) > 4. create a db-useraccount, so the users can login > with that > > I do not use SQL server, but the keywords are the > same in most SQL DBs: > look for help in > CREATE ROLE > GRANT > REVOKE > Have fun, keep calm > Bob > > > > Does anyone out there know how to write a > trigger in > > SQL Sever. > > what I need is a trigger that will store in a > table > > the user Id of someone who went in and changed > a line > > in a storedProc on the server and one that > will store > > the Stored procedure code as well as what it > is when > > someone has changed the code.. > > I need this because someone at work is > changing my > > code and knowone will own up to it.. so I need > a way > > to track this in a trigger... is this > possible...? > > > > MC > > > > > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! Small Business - Try our new resources > site! > > http://smallbusiness.yahoo.com/resources/ > > > > > > > ----------------------------------------------------- > > Home page: > http://groups.yahoo.com/group/delphi-en/ > > To unsubscribe: > [EMAIL PROTECTED] > > Yahoo! Groups Links > > > > > > > > > > > > > > > > ---------------- End of Body ---------------- > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
