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)
Best Answer
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.