Cannot open database Properties window

Peter
When you open Properties of the database , SQL Server runs DBCC command (you
see in the erro message) and to run it you have be a member of the sysadmin
fixed server role, the db_owner fixed database role, or the db_ddladmin
fixed database role.






"Peter" wrote in message
news:1397B28B-E992-46F9-AB79-3FAC0DBBB0D8@microsoft.com...
> I'm trying to open the master database Properties window when running SSMS
> as
> a local user (Run as) which I have only created a sql server login for it.
> I
> get the error below. If I add the sql server login as a user to the
> master
> database and assign any database role membership except db_owner to that
> user, I still encounter the same error or other permission error.
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> Cannot show requested dialog.
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Cannot show requested dialog. (SqlMgmt)
>
> ------------------------------
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
>
> User 'guest' does not have permission to run DBCC showfilestats for
> database
> 'master'. (Microsoft SQL Server, Error: 7983)
>
> For help, click:
> http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>