June 29, 2010 at 6:02 am
I am running sql 7.0. I have a table with a user that keeps losing its permissions. Every morning I have to add the users permissions back to the table. Any idea what I am doing wrong?
June 29, 2010 at 6:03 am
Is the table getting dropped and recreated overnight?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 29, 2010 at 7:21 am
No the table gets emptied and repopulated but I have to add the permissions back first. After it gets repopulated I checked and the permissions are still there. I can't find a job that runs overnight that removes the permissions It just happens overnight but I have looked at all my jobs and noe of them delete the table. The table is still populated when I come in every morning.
June 29, 2010 at 7:31 am
I suspect you'll have to run a trace to see what happens. Either the table is being dropped and recreated or something's explicitly removing permissions.
Does SQL 7 have profiler?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply