| Author |
Topic |
|
Dallr
Yak Posting Veteran
87 Posts |
 Posted - 2008-07-29 : 22:03:38
|
| Hello, all I know this is an easy question. How do I used [b]SSMS[/] to find out all the users that are mapped to a specific login. So lets say I windows group (Domain) with five users and I have created a login for them which is mapped to a particular database. How can I use SSMS to identify all the users assigned to this login?Thanks in advance for you assistance. Dallr |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-29 : 22:09:42
|
| Check out Tara's nice information:http://weblogs.sqlteam.com/tarad/archive/2008/06/23/How-to-get-information-about-Windows-users-and-groups-using.aspx |
 |
|
|
Dallr
Yak Posting Veteran
87 Posts |
Posted - 2008-07-30 : 05:58:48
|
| Thanks for the link Sodeep. I have tagged it for future reference. However, I was asking how do you know the SQL SERVER Users that are mapped to a login using SSMS.Dane |
|
|
|
pootle_flump
1064 Posts |
Posted - 2008-07-30 : 06:16:18
|
| sp_helplogins 'mylogin name' |
|
|
|
Dallr
Yak Posting Veteran
87 Posts |
Posted - 2008-07-30 : 09:33:07
|
| Two things.1. So are you saying there is no way that this can be done using SSMS itself?2. I am also not getting replies to this post although I subscribed to it. I have checked my spam/junk mail folder and replies are not their either.Dane |
|
|
|
pootle_flump
1064 Posts |
Posted - 2008-07-30 : 10:15:44
|
| 1. Ya mean via the GUI? Stuff the GUI - use it only when you can't get something easily in code. Trust me - you will learn to love code and hate GUIs. You can run the above so quickly in SSMS: Ctrl + N opens a new query window. Paste the code in, change the login name, hit F5. Easy peasy and you can save the script in your library for quick re-execution (admittedly you might not with something this trivial but get into the habit and you will only have to learn how to do something once - all subsequent times you have a script ready and to hand).2. No idea sorry |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-30 : 21:35:00
|
| 1) You are not clear with your question2)Did you see the link I provided?after that ask question so we can understand. |
|
|
|
Dallr
Yak Posting Veteran
87 Posts |
Posted - 2008-07-30 : 23:08:10
|
| Thanks for responding Pootle_Flump. I actually love to use scirpts (i.e programming) to get things done in IDE's. I am new to SQL server and I would like to know how to do things in both ways. I guess the SP sp_helplogins is the way to go then. Dane |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-30 : 23:17:49
|
| >> how do you know the SQL SERVER Users that are mapped to a login using SSMS.Do you mean 'sql server login that mapped to a db user'? If so, login's properties -> user mapping. It'll tell you which db the login has access to and db user name mapped to. |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2008-07-31 : 14:28:43
|
| In SSMS try looking under the security section of the database you want to know about, right click on the user that you need the information about and there it shows which login this user is mapped to.Hope this is what you are after anyway***************************Life is for having Fun, and then a little SQL Server on the side |
|
|
|
|
Users Mapped to a login