November 2, 2010 at 1:03 pm
Hi,
I mapped a user to a specific database and gave read permissions. I then pressed ok.
If I close the properties window and open it again, the mapping to that database is lost. I did this several times but its not working.
Can any one of you please help me in achieving this ?
Thanks in advance
November 2, 2010 at 1:12 pm
I had a similar issue with this when it came to a restored db which contained an old schema related to the user being created. I had to drop the schema and start fresh.
I would go to the db security node directly and have a browse for similar named objects.
November 2, 2010 at 1:14 pm
did you actually refresh the database in the object explorer ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 2, 2010 at 1:17 pm
Under db security - > under schemas , I see a schema with the same UserName. can I drop it ?
November 2, 2010 at 1:19 pm
Yes I refreshed but not working
November 2, 2010 at 1:23 pm
Did you map the user to the correct database ?
I suppose you have more than one userdb.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 2, 2010 at 1:29 pm
Yes i am mapping it to correct database.
November 2, 2010 at 2:51 pm
There was a existing schema owned by him in the database. So, When I dropped the schema I was able to map him to that database.
November 2, 2010 at 2:52 pm
Thank You all for your quick help.
November 3, 2010 at 12:56 am
next time, if you know this is a restored/attached db, I guess it will be easier to just run:
ALTER USER [username] WITH LOGIN = [loginname]
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply