Viewing 15 posts - 9,586 through 9,600 (of 9,720 total)
Anil,
Unfortunately, this is something that is changeable depending on what types of information you keep track of in your database and what type of business you have.
Part of our SOX...
July 6, 2007 at 7:11 am
I can hardly find anything in BOL about either NTLM or Kerberos. What I can find seems to indicate this is a server setting, not a SQL setting. Any thoughts...
June 22, 2007 at 4:27 am
Steve,
Unfortunately, even that practice wouldn't fly at my work place. Everything must go through a rigorous SDLC. We put things into Test, have the BAs test it. We put it...
June 21, 2007 at 8:12 am
I double-checked. Only one of my servers is using a different domain account than the other 3, and that wasn't the server I was trying to link to. The other...
June 21, 2007 at 7:46 am
Can you imagine what would have happened if that email had been intercepted by a malicious user / hacker?
YIKES!!!
June 21, 2007 at 7:16 am
Actually, all the servers are running under a domain user account and they should be (I'll have to check) running under the same one. We have to use domain user...
June 21, 2007 at 6:09 am
Thanks, Carter. It's nice to know I'm not the only one with issues regarding this.
I might submit this to MS as a bug in the GUI unless someone can point...
June 20, 2007 at 8:52 am
I've added feedback to Microsoft's site. If anyone would like to vote on the issue it's located at: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=283525
Issue ID 283525 and titled "DDL Triggers do not restrict sp_AddRoleMember".
Thanks...
June 20, 2007 at 6:16 am
The situation is that some of the Developers have access to a SQL Server login with DB_Owner permissions (and password) so they can give our application access to a specific database. And since the...
June 20, 2007 at 6:03 am
Thing is, I don't want to just monitor them. I want to prevent anyone from using them and record the efforts of those who try to add users to roles. ...
June 19, 2007 at 10:25 am
Oh, I forgot to mention that I did indeed add log code (as you can see above), but the code didn't log anything even when the trigger did work correctly.
Maybe...
June 19, 2007 at 8:28 am
Steve,
Since I posted my problem, I've actually tested the sp_adduser event against my triggers and the triggers do indeed work against that even though I'm a sysAdmin. They just don't...
June 19, 2007 at 8:26 am
Loner,
I'm glad we could help. From what you've just posted, it seems you're in a lose-lose situation. Personal life stress has crossed into work stress and work stress has crossed...
June 13, 2007 at 7:14 am
Gift,
I'm also a woman in IT, but that doesn't mean I believe exercise solves all problems. Being an ex-athlete, I won't disagree that it helps. I can't get through a...
June 13, 2007 at 5:18 am
Now there's a thought that never occurred to me. And it should have considering how many chronic & manic depressives I know. Chronic / Clinical Depression is one thing I...
June 12, 2007 at 4:54 am
Viewing 15 posts - 9,586 through 9,600 (of 9,720 total)