RE: Database Roles
- From: weilu@xxxxxxxxxxxxxxxxxxxx (Wei Lu)
- Date: Tue, 02 May 2006 06:07:13 GMT
Thank you for using MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You want toassign a database role to be a member of another database role. If I
misunderstood your concern, please feel free to let me know.
You can not assign a database role to be a member of another database role.
If you want to grant the same permission of another database role and
extend the permission, please grant the CONTROL permission to the database
role for your additional database role.
Thank you for taking the time to provide feedback on this product.
We are very interested in your thoughts and opinions for improvements that
we can make to provide the features and functionality you and your
customers would like to see.
To provide your feedback, please go the following website:
Microsoft Online Community Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
Thread-Topic: Database Rolesapproach
From: =?Utf-8?B?bWljaGFlbA==?= <howlinghound@xxxxxxxxxxxxx>
Subject: Database Roles
Date: Mon, 1 May 2006 11:47:02 -0700
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.security:27213
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
In SQL Server 2005, I want to create a database role and then create
additional roles based on the earlier role (sort of an inheritance
to creating roles). However, I can't seem to find a way to make one role a
member of another, share schema... Is this possible or advisable?
- RE: Database Roles
- From: michael
- RE: Database Roles
- Prev by Date: Re: Permissions on sp_OASetProperty
- Next by Date: backup\restore password?
- Previous by thread: Re: sqlBulkCopy and required permissions
- Next by thread: RE: Database Roles