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 |
|
merrittr
Starting Member
10 Posts |
 Posted - 2013-11-22 : 11:17:44
|
| I have 2 users in sql 2008 r2 one can select from sys.sysprocess and run sp_who and see other proc ids and KILL them (Looks like they have processadmin role but it doesnt show up???) the other can only see their process ids now both are able to access the database due to being in the sam ad group how do I look at their permissions if they do not have a principal ID entered in SQL just the domain group they are both in??for instance this wont workEXECUTE AS USER = 'DOMAIN\USERNAME' SELECT * FROM fn_my_permissions(NULL, 'SERVER'); |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
using AD group to grant permissions question