Re: What is "via group membership"
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Wed, 1 Mar 2006 08:54:21 +0200
Sue
If you
execute sp_addsrvrolemember to add the Windows account to a
fixed server role, the login will be listed with Server
Access Via group membership.
I did some testing just and it did not show up Via group membership
EXEC sp_addsrvrolemember @loginame='WINDOW\John',@rolename = 'sysadmin'
"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:hs0a02pj2lc9joitocioepfv3ob1epthks@xxxxxxxxxx
It's a matter of how the login was added to SQL Server.
Windows accounts can be granted access to a role without
having explicitly added them as a login first. If you
execute sp_addsrvrolemember to add the Windows account to a
fixed server role, the login will be listed with Server
Access Via group membership.
-Sue
On Tue, 28 Feb 2006 15:31:51 -0800, Budman
<Budman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Can someone please explain the Server Access option "via group
membership"?
This is found on the Logins screen in Enterprise Manager. It does not
appear
on the Create New Login form. What are the implications of a login with
this
server access setting?
.
- References:
- Re: What is "via group membership"
- From: Sue Hoegemeier
- Re: What is "via group membership"
- Prev by Date: Re: Adding /Verify permissions to an AD user on a remote database
- Next by Date: Re: What is "via group membership"
- Previous by thread: Re: What is "via group membership"
- Next by thread: Re: What is "via group membership"
- Index(es):
Relevant Pages
|
