I am the sysadmin on a small SQL Server. Can I store rules in the Databases that prevent certain types of SQL statements to be run? Example would be when a user tries to execute SELECT * FROM ... Can I "ban" these types of solutions? Other examples I would like to ban would be create ##Temp Tables in memory, or even creating a table / querying a table without a Primary Key.
It would be great if I could display a message saying why this statement isn't allowed with a message of my choosing.