Administration > 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.
Was this helpful?