Rights to the tables disappear from the role.

From: sqlguy (ppandya_at_orthodon.com)
Date: 06/25/04

  • Next message: sql_Michael_dotnet: "Inserting XML Data Into a New Table FROM VB.NET" 
    Date: 25 Jun 2004 08:10:35 -0700

    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 with
    out success!! I have never seen something like this happen before.
    Can anyone please help!
    Thank You,
    -Pranay

  • Next message: sql_Michael_dotnet: "Inserting XML Data Into a New Table FROM VB.NET"
    Loading