djj (3/3/2015)
I guessed correctly, however, how does this prevent the user from creating in other schemas? Is it because he has not been given permission explicitly to them?
Correct. Steve has not been granted "Authorization" to any other schema other than the schema "Steve".
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events