Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a contractor setting up a database application. The database is set up, the login for the app is set as the database owner, but has only 'public' at the server level.

When the contractor logs into SSMS with the database login, he sees no information in the Database Properties > Files page -- the table is empty. However, exec sp_helpdb database; returns all the info that should be showing in Properties.

Are there any rights I can grant that will show the file info in Properties, without granting excessive rights to anything else?

(SQL Server 2008 R2)

share|improve this question
I haven't tried it, but you could set up a custom report in SSMS that queries sys.databases and sys.database_files. I don't use SSMS for this kind of stuff so it doesn't bother me: but I know what you mean – gbn Mar 22 '12 at 19:59
up vote 3 down vote accepted

If I'm understanding correctly I believe you need to grant VIEW DEFINITION to your contractor's account. You can do this only on the DBs you want the contractor to access.

share|improve this answer
Thanks, that put me on the right track -- I actually needed to grant VIEW ANY DEFINITION to get the files to show in the Properties dialog. – scotth Mar 23 '12 at 15:04

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.