Administration > SQL Server Administration > Introduction to SQL Server Administration > Users authorized to perform administration functions (SQL Administration)
  
Users authorized to perform administration functions (SQL Administration)
The following user roles can perform administration functions:
• Users with the instance administrator role.
• Users with the database administrator role.
* 
Users with administrator access permissions can view table data in SQL Server Management Studio.
Standard users cannot view table data in SSMS, and they can only execute stored procedures.