Re: via group membership
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/03/03
- Previous message: Matt Troska: "Re: Builtin Administrators Group and SQL Agent Jobs"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 03 Nov 2003 13:33:11 -0700
For databases users, it's just the difference of how they
were given access to the database. For example, if you have
a Windows account and haven't granted that account access to
the server (i.e. no login), you can add the Windows account
directly to a role in a database with sp_addrolemember -
even though they don't have a login set up on the server.
When you do this, you will see the user in the database with
database access as Via Group Membership.
For the server logins, same type of thing. If I have a
Windows account that has not been granted access to the
server yet, I can execute sp_addsrvrolemember to add that
Windows account to a fixed server role. The login will then
be listed with Server Access Via group membership.
-Sue
On Thu, 30 Oct 2003 14:14:46 -0800,
<cordelia.goh@gvrd.bc.ca> wrote:
>Under what circumstance will "via group membership"
>appear under "Server Access" (in SQL 2000) and "Databaes
>Access" (in SQL 7). How is it different from "Permit"
>operationally or otherwise?
- Previous message: Matt Troska: "Re: Builtin Administrators Group and SQL Agent Jobs"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
