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 ---------------- ----------------------------------------------------- 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/
