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 |
|
Kimi86
Yak Posting Veteran
79 Posts |
 Posted - 2012-07-17 : 05:30:50
|
| I need to find out accress and permission of Two users Mark and Mike on a database. Both users should just have READ ACCESS on teh databaseMark 1. In the server security node -> Logins i dont see this user present. There is only 1 login present called SQLALLUSERS but I am not able see if Mark is mapped to this login2. Under database Security Node I cannot see this User againMike1. In the server security node -> Logins i dont see this user present. As I said there is only 1 login present called SQLALLUSERS but I am not able see if Mike is mapped to this login 2. Under database Security Node I DO see Mike. On checking properties i can see he is assigned to db_datareader roleI need to give both of them Read Access. I need to know what to do for eachAlso Would like to know why I am not ale to see Users mapped to login. I though i should be able to see Mark and Mike somewhere assigned to SQLALLUSERS. Let me know if i can give some other info |
|
|
Kimi86
Yak Posting Veteran
79 Posts |
Posted - 2012-07-17 : 10:02:11
|
| either my question is too dumb or just does not make sense.. Guessing this since i have not got a single reply yet.. please guys any hint will be helpful |
 |
|
|
|
|
|
User login mapping related issue