Privileges for geodatabases in SQL Server
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 User geoprocessing tool.)
