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 |
vicsense
Starting Member
1 Post |
Posted - 2005-09-05 : 18:29:52
|
I have a problem, an user tried to enter an application and it displays an error message, saying his user doesnt have permissions to enter that DB. And the user exists as Login in SQL Server and as user in the DB, I try to check the permissions in the DB and it displays the next message "Error 15001: Object '(null)' does not exist or is not a valid object for this operation", then I tried to assign to it a role, but it displays the error 15410: user or role does not exist in this database. Then if I want to delete it it displays error 15008: User does not exist in the current database. And if I want to assign permissions to the DB from Security->logins it shows the error 21002:[SQL-DMO] User already exists.Can anybody help me??TIA |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-09-05 : 21:37:20
|
you probably have an orphaned user,try sp_change_users_login and see if it works for you...HTH --------------------keeping it simple... |
|
|
|
|
|