Re: Architecting Management of groups of objects

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 01/10/03 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Fri, 10 Jan 2003 07:50:38 -0700

The closest I can think of is A -> G. Add the Global group
to SQL role (it's then in local security context - similar
to adding the global group to a local group). Apply
permissions on the SQL role.

-Sue

On Tue, 7 Jan 2003 12:02:50 -0800, "Tony Su"
<tonysu@su-networking.com> wrote:

>Hello,
>Am attempting to mirror Windows SysAdmin AGLP in managing
>User access to groups of objects.
>
>Review:
>MS SysAdmin security model
><indiv User><><UserGroup><><ResourceGroup><><indiv
>resource>
>
>What SQL clearly supports now:
>Through SQL security or Windows Integrated, Windows User
>Groups and/or roles can be implemented as a "container
>group" to manage Users and User Security
>
>Is there a ready solution or solution example for what
>remains?
>The second half... managing individual objects as groups
>is not ready made. Is there a totally flexible solution
>which enables an application to create Resource groups
>which can contain random (not necessarily fixed)
>collections of table records? One of the features of
>Windows SysAdmin I'd like to support is the ability for
>the User to create and define new groups without having to
>contact a Developer.
>
>TIA
>
>Tony Su

Quantcast