Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
steurm
Starting Member
2 Posts |
 Posted - 2004-10-13 : 04:23:04
|
| We have a strange problem. We have a user setup to have access to a database, which is used in a asp-webapplication. Every once and a while, the user of the webapplication that connects to the database, looses its permissions. We have no clue why this happens. Anyone with a clue ?Steurm |
|
|
chenthorn
Starting Member
6 Posts |
Posted - 2004-11-17 : 12:04:20
|
| I just had the same issue. Web page logs into server to run search sproc. Ran fine until this morning when db user acct. lost all Search and Execute permissions. What gives? |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-17 : 12:28:11
|
| Object (table, view or SProc) dropped and recreated?Kristen |
|
|
|
chenthorn
Starting Member
6 Posts |
Posted - 2004-11-17 : 13:11:44
|
| As far as I can tell, nothing was dropped or recreated. This db has 9 tables and 3 stored procedures that have search or exec permissions on them. My QA dept was checking hte web site about an hour before this event happened and it was working fine. After the website was reported as down, ALL permissions for this user in the db were gone. I was able to reset them without issue, but it is curious that this would happened. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-17 : 16:06:12
|
| Have a go withSELECT TOP 10 O.crdate, O.xtype, O.nameFROM dbo.sysobjects OORDER BY O.crdate DESCto see what has changed recently??Kristen |
|
|
|
steurm
Starting Member
2 Posts |
Posted - 2004-11-17 : 16:44:58
|
| The problem we had was solved. It seemed to be MBS Navision that caused the problem. Navision synchronizes its users with the SQL security. The webapplication was accessed by a user, not known to Navision, which denied access to the user.Steurm |
|
|
|
|
|
|
Permissions are getting lost