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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2004-09-06 : 11:31:45
|
| How to find the access details for a perticular user?------------------------I think, therefore I am |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-09-06 : 11:33:49
|
will this help you:exec sp_who 'UserName'Go with the flow & have fun! Else fight the flow  |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-09-06 : 11:55:47
|
| sp_who gives the details about the processes running on SQL server. I need the access information..for e.g. a user has access to select the data from a perticular table or not?------------------------I think, therefore I am |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
|
|
nbpatil
Starting Member
14 Posts |
Posted - 2004-09-08 : 03:51:03
|
| Hi Ravi,Nitin here!Open your server->Security-> Logins ->select particular user & open up properties.Open database role properties.Here you will find SELECT/INSERT/DELETE/MODIFY etc permissions.You can create user defined groups for different users.For each database and table u can control access. |
|
|
|
|
|
|
User access