Re: Triggers on system tables

From: Ranjit Wimalaratne (anonymous_at_devdex.com)
Date: 04/25/03 

Date: Fri, 25 Apr 2003 03:06:07 -0700

Dear Dejan,

I suspect a security breach on SQL SA password and wnated to know who
modifies the sysmembers tables to add him to the DBO role by setting a
trigger on it.

Thanks for the rep[ly.

Ranjit

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Project and SQL role/user dbo problem
    ... I'm having the strangest thing with sql objects ownnership when i'm using ... SQL Analyzer, Enterprise manager, no problem, my user has the dbo role, he ... I can't use User authentication in SQL because there is way too many users, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Database program to just work with text files?
    ... > Does anyone know if there exists a database program for Linux that ... > just modifies one or more text files? ... It's not SQL, it's a totally different way of handling data, that may be ... > values and I want to query it with SQL statements rather than look ...
    (comp.os.linux)
  • Active Directory / Groups + MS SQL (yikes???)
    ... When configuring ms sql to permit authentication from users over a ... sysmembers / sysgroups / etc what active directory group's a specific ... user is a member of once they are authenticated into a ms sql server? ...
    (microsoft.public.sqlserver.security)