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 |
|
interclubs
Yak Posting Veteran
63 Posts |
 Posted - 2002-05-16 : 22:18:08
|
| I keep trying to alter a table both thru EM and thru the QE...I keep getting this error:- Unable to preserve security settings for user ''. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is no such user or group ''.When I view the script it creates to edit the table, it has this line in it:GRANT REFERENCES ON dbo.NEWS TO [] AS dboI am assuming the square shouldn't be there. Tried creating new users, logging in as SA, just about everything. Just doesn't seem it passing my user info. with the queries, and its only for this one DB which is the odd part, all the other ones are fine. Any clue, its making it hard to make changes...guess I can finish watching ER. |
|
|
interclubs
Yak Posting Veteran
63 Posts |
Posted - 2002-05-16 : 22:34:45
|
| I take it back, it seems to only be this one table. |
 |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-05-17 : 10:37:33
|
| A temporary fix might be to copy the script that EM generates and run it manually in QA, replacing the square with the appropriate user. If the problem is only on this one table, it might be easiest to resolve by dropping and recreating the table. Then reassigning the appropriate permissions.Jeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
One DB no longer recognizes my security settings