Re: Adding role to roles?
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Thu, 16 Feb 2006 19:58:22 -0700
A couple of the limitations are that you can't add a fixed
database role to other roles - which is probably what you
are seeing. And the other would be that you can't create
circular roles - you can't add role1 to role2 if role2 is
already a member of role1.
You can create your own user defined roles and can add these
to fixed database roles. You can also add user defined roles
to other user defined roles.
-Sue
On Thu, 16 Feb 2006 08:17:08 -0800, "Mark"
<Mark@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hello,
Is it possible to add a dbrole as a member or another dbrole? When I try
and add members to an existing role all I see are dbusers, but I've looked at
some other sample dbs and noticed what appeared to be dbroles as members of
other dbroles.
Any help would be greatly appreciated!
Thanks in advance.
.
- Prev by Date: Re: Move 10 DBs and provide dev access thru EM?
- Next by Date: Re: sql server 2005 permissions - how to view
- Previous by thread: Re: SQL thinks it's Slammer
- Next by thread: Re: sql server 2005 permissions - how to view
- Index(es):
Relevant Pages
|
