Tip: Privileges for geodatabases in SQL Server

[BillFox]

Privileges for geodatabases in SQL Server—Help | ArcGIS for Desktop 

• If you want data creators to be able to see existing users and roles in the database, you must grant them VIEW DEFINITION privileges on the database. (This is granted automatically to users you create using the Create Database Usergeoprocessing tool.)