May 16, 2002 at 7:58 pm
No matter who i login to my DB as, and no matter what changes I make, I get the following error:
'NEWS' table
- Unable to preserve security settings for user ''.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is no such user or group ''.
Any Ideas?
May 16, 2002 at 8:00 pm
Hmmm...When i Look at the script it generates to make the change to the database, this line comes up:
"GRANT REFERENCES ON dbo.NEWS TO [] AS dbo"
I am assuming the square shouldn't be there. Anyone have any ideas?
May 16, 2002 at 8:12 pm
Are you doing this in EM or other. Use Profiler to trace the statement to see what is suubmitted to make sure you are delivered good data.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 16, 2002 at 8:28 pm
I tried it in EM and in the QE... And I tried it directly on the machine running the DB. Just seems like it doesn't pass any user information to the DB and thus won't make the changes.
Weird part is it is only on this one DB, all the other ones on the machine are fine.
Edited by - interclubs on 05/16/2002 8:29:59 PM
May 16, 2002 at 8:57 pm
HMMM.....It only seems to be this one table.
May 17, 2002 at 4:45 am
If you do not have any data in this table then delete it and rebuild it to see if fixes. If you do then create a new table with the same structure and import the data from NEWS into it then drop the NEWS table and rename the duplicate to see if fixes. Or when things are not busy backup the database to file, bcp out the data, drop the table, remake the table and bcp in the data (backup is for safety in case bcp is an issue, might try DTS import export as well. Seems like the tables metadata may be an issue in some way. To test without dropping the table use EM to copy the tables DDL by right clicking the table and select copy then paste in QA adjust for name conflicts and build a copy of the table. Then try to grant, if works then it is the table somehow.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply