Determining windows grouop membership of a SQL login
- From: "Keith" <keith@xxxxxxx>
- Date: Thu, 9 Aug 2007 10:31:24 -0700
Hello,
I'm trying to determine the windows group membership of a SQL login I've
created from a Windows login. Specifically, I'm trying to determine if the
login is in BUILTIN\Administrators or otherwise has admin permissions. For
example,
CREATE LOGIN <login> FROM WINDOWS WITH DEFAULT_DATABASE <database>
USE <database>
CREATE USER <login>
The CREATE USER call will fail if the login has admin privs because they
already have access under 'dbo'. So how do I go about determining the
membership of this login? sp_helplogins, sp_helpuser, sp_helpgroup don't
seem to provide the information I need.
Suggestions?
Keith
.
- Follow-Ups:
- Re: Determining windows grouop membership of a SQL login
- From: Russell Fields
- Re: Determining windows grouop membership of a SQL login
- Prev by Date: User can't be deleted because it has granted/denied permissions on objects
- Next by Date: Re: Create table in schema
- Previous by thread: User can't be deleted because it has granted/denied permissions on objects
- Next by thread: Re: Determining windows grouop membership of a SQL login
- Index(es):
Relevant Pages
|
|
