Re: via group membership

From: Steve Thompson (SteveThompson@nomail.please)
Date: 02/20/03 

From: "Steve Thompson" <SteveThompson@nomail.please>
Date: Thu, 20 Feb 2003 09:04:57 -0500

"cordelia" <cordelia.goh@gvrd.bc.ca> wrote in message
news:021f01c2d872$b0bea270$a501280a@phx.gbl...
> In EM,I've seen "via group membership" under the 'Database
> Access' column on the right pane of the 'Users' of an user
> defined database.
>
> What is "via group membership" about? Under what
> circumstance would one find use for it? Couldn't find any
> write-up on that?

That implies that a user with a valid windows account, has access to a
database (or databases), via a NT Group membership. For example, if you have
a default SQL Server 2000 install, the builtin\administrators group has
sysadmin equivalence, anyone that has local administrative rights on the
server will have sysadmin equivalence and may appear in EM via the group
membership.

Steve

Relevant Pages

  • Re: Cannot get AD groups to work in SQL 2k5
    ... I would expect users to be able to connect via group membership. ... SQL Server MVP ... and assigned a default database to the group. ... For some odd reason my ...
    (microsoft.public.sqlserver.security)
  • Re: Different FEs for different users
    ... When there is user-level security I have used group membership to show or hide controls, ... The database uses a startup form that includes the command button cmdSecurity, which opens a form that includes toolbars and other information used to administer database security, but it could have been any form. ... I would further like for the clerks to only have limited access and editing ...
    (microsoft.public.access.tablesdbdesign)
  • What are the differences between these types of NT groups?
    ... writes their AD group membership to a database table. ... Dim arrGroups, strGroup, objGroup ...
    (microsoft.public.scripting.vbscript)
  • Re: Which User account is used?
    ... The xp_logininfo documentation implies that admin privilege Windows group membership takes precedence over non-admin group membership and that the earliest granted Windows group is the one used for ties. ... user who is a member of an AD group which has been assigned as a database ... How does SQL Server decide which User account is used when this user ...
    (microsoft.public.sqlserver.security)
  • Re: How limit records returned by SQL Query based upon user group/class
    ... How would you use system_userin a join to determine group membership? ... support the retrieval of them. ... to be able to indicate whether it is a public document or limited to a ... What is the best mechanism (assuming IIS and SQL Server with Windows ...
    (microsoft.public.dotnet.framework.aspnet)