RE: Which Groups and what are effective permissions based on multiple groups?
From: Sophie Guo [MSFT] (v-sguo_at_online.microsoft.com)
Date: 02/24/05
- Next message: Tibor Karaszi: "Re: Transaction log too big"
- Previous message: Kalen Delaney: "Re: Insert output of sp_helpdb {dbname} in only one table"
- In reply to: Sgt. Sausage: "Which Groups and what are effective permissions based on multiple groups?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 24 Feb 2005 06:38:36 GMT
Hello Sgt.,
You can use xp_logininfo to get the group name which the user belongs to.
For example, if you have a Windows user John who belongs to the Windows
group test_permission, you can perform the following steps:
1. Run sp_who to get a user name. For example, 'test\John'
2. Run xp_logininfo to check the Windows group which the user belongs to.
For example, run the following command:
EXEC master..xp_logininfo 'test\John'
The results are as followings:
Account name type privilege mapped login name
permission path
----------------------------------------------------------------------------
--------------------------------------------------
test\John user user test\John
TEST\test_permission
You can know that test\John belongs to the Windows group
TEST\test_permission.
3. Run sp_helprotect to check the group's permission. For example, run the
following command:
sp_helprotect null, [test\test_permission]
I hope above information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
- Next message: Tibor Karaszi: "Re: Transaction log too big"
- Previous message: Kalen Delaney: "Re: Insert output of sp_helpdb {dbname} in only one table"
- In reply to: Sgt. Sausage: "Which Groups and what are effective permissions based on multiple groups?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
