November 14, 2008 at 3:10 pm
Hi Guys,
I have several users of the database and they are mapped to the login ( Suppose User 'A' is mapped to Login 'B'). I have a question now , how do I query to find out which user is mapped to which login.. Ideally, I want to create a table with two column where I want to insert the users in the first column while their corresponding login in the other column.
Please respond
Thanks
November 14, 2008 at 4:12 pm
system stored procedure sp_helpuser will return this information for you
---------------------------------------------------------------------
November 17, 2008 at 2:12 pm
I think this thread has what you need.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 17, 2008 at 4:29 pm
Hey guys,
Thanks for the reply. Actually I got the answer after I started the thread.What I did was queried the server_principal and database_principal and got what I wanted. If you guys want I can post the code.
Cheers
November 21, 2008 at 6:31 am
Please Post it.
regards,
mohideen
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply