May 5, 2003 at 4:00 am
Have got 3 clients connected to the server. Created a user from security|logins. The user can only be seen in the database by one of the clients and not the other 2. Need to change the user's permissions, but attempts from security|logins thwarted because the user already exists and can't delete them to re-create them - my client is one that can;'t see the user insdie the database.
Any ideas?
May 5, 2003 at 4:33 am
Try the following
Issue sp_dropuser 'username' on the database
in query analyzer.
Then user enterprize manager to set the permissions again on database
May 5, 2003 at 4:59 pm
Did you restore a db? EM has some issues here, I often have to refresh a few times or resynch the logins with sp_change_users_login.
Steve Jones
May 5, 2003 at 5:45 pm
No - the user was newly created in the DB. Tried refresh - even left i a day, still not visible!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply