CODEWITHSUNDEEP
sqlsql-serversql-server-2008sql-server-2008-r2ssms
winman
winman

Reputation: 219

Sql server 2008:Permission to access database properties

What is the minimum permission(server roles and user mapping) by which properties of database can be viewed in sql server 2008? Now i hav given only public and datareader in user mappings and public in server role.When i right click on database and click on properties i am getting error like "User '' does not have permission to run DBCC showfilestats for database '"

Upvotes: 0

Views: 2396

Answers (1)

dferidarov
dferidarov

Reputation: 602

You need to have access to db_owner fixed database role or Sysadmin fixed server role.

Upvotes: 2

Related Questions