Re: Strange - grant alter on role = cannot see securables for user
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Mon, 7 Sep 2009 21:56:58 +0000 (UTC)
Doug (nospam@xxxxxxxxxxx) writes:
Wondering if anyone else has run into this? I have some development
databases that developers have privileges in. One of the privileges is
"alter role" on a new db role developed for the app hitting the database.
When you grant this, then use SSMS to have a look at the user, when you
click Securables, a (truncated) error message pops up. Remove the alter
permission on the role and the securables can again all be seen.
If you have not seen this, please do a small experiment and let me know
how yoours goes. My SQL 2005 clustered instance is at Svc Pack 2, my
SSMS client is at Svc pack 3.
I ran this:
create database newdatabase
go
use newdatabase
go
create user hampus without login
create role rolle
grant alter on role::rolle to hampus
Then I used Object Explorer to look at the user Hampus. When connecting
from SSMS 2005 to SQL 2005 I got the error. When connecting from SSMS 2008
to SQL 2008 I did not get the error, so it seems the issue has been
addressed.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- References:
- Prev by Date: Help with SSRS 2008 report sorting
- Next by Date: Re: Can't re-save a Table
- Previous by thread: Strange - grant alter on role = cannot see securables for user
- Next by thread: Re: Strange - grant alter on role = cannot see securables for user
- Index(es):
Relevant Pages
|
