So I've had a few co-workers from Aqua Data Studio to SSQL, and everyone seems to be pretty happy so far.

Alot of times in the past people were enforcing "Client Side Permissions" only enabling select sql statements.... Is there anyway to do this in SSQL?

Basically, I want to make a alias read only, just incase our DBA forgot to enforce restrictive permission.

Any tips appreciated,