User ‘public’ does not have permission to run DBCC showfilestats for database ‘ testing’
This error message is raised when your user account does not have the db_owner role of a database meaning you are not the owner of the database; and you try to open the properties dialog box of a database in SSMS 2008.
User ‘<User>’ does not have permission to run DBCC showfilestats for database ‘<Database Name> ‘.
Cause:
This happens when you right click on a database in SSMS and click properties of the database; In response SQL Server 2008 runs the DBCC SHOWFILESTATS command to fetch the UsedSpace property and the AvailableSpace property. Because the user is not the db_owner, the user does not have permission to run the DBCC SHOWFILESTATS command. Therefore, the user cannot open the Properties dialog box in SSMS 2008.
Resolution:
No comments:
Post a Comment