RE: Weird table rights issue

From: Chris Wilkins (ChrisWilkins_at_discussions.microsoft.com)
Date: 06/28/04

  • Next message: Chris Wilkins: "Re: sqlmangr.exe attempts to access 255.255.255.255 (ZoneAlarm Pro" 
    Date: Mon, 28 Jun 2004 08:26:01 -0700

    The first thing I would do is setup a trace against that database using SQL profiler. That's probably the only way you're going to be able to see the exact chain of events against the table.

    "sqlguy" wrote:

    > I have a role which has access to two tables. Every morning when i
    > come, the role has lost access to those two tables. So i go to
    > enterprise manager again and go to the table and give permission to
    > the role again for select, insert and update. I have been doing this
    > daily for 5 days now and also trying to find out why this happens!! I
    > have never seen something like this happen before.
    > Can anyone please help!
    > Thank You,
    > -Pranay
    >

  • Next message: Chris Wilkins: "Re: sqlmangr.exe attempts to access 255.255.255.255 (ZoneAlarm Pro"

    Relevant Pages

    • Re: SQL Profiler - SPID
      ... What is the SPID column for in SQL Profiler? ... I have tried database name but that doesnt work. ... If for some reason the DatabaseName filter doesn't work, ... I also suggest you try out the tool SQL Trace Analyzer. ...
      (comp.databases.ms-sqlserver)
    • Re: DatabaseName Database ID Map?
      ... (Reverse address to reply.) ... > In SQL Profiler, it is easy enough to the the database ID from a trace. ...
      (microsoft.public.sqlserver.programming)
    • DatabaseName Database ID Map?
      ... In SQL Profiler, it is easy enough to the the database ID from a trace. ... How can I map the database ID to it's human-friendly name? ...
      (microsoft.public.sqlserver.programming)
    • Re: SetUp functions for multiple test cases
      ... couldn't find out how to implement a setup function, ... new database in-memory and fill it with example data for every single ... The True Unit Test Zealots will argue that all tests should be 100% ... SUnit from Smalltalk to Python: SUnit takes full advantage of ...
      (comp.lang.python)
    • [NEWS] Lawson Financials RDBMS Insecurity
      ... Beyond Security would like to welcome Tiscali World Online ... the database itself) to easily compromise the Lawson Financials' database. ... Setup #1 tends to be the preferred configuration method by Lawson ...
      (Securiteam)