Raghavendra Mudugal (3/3/2015)
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?In a way, Yes. In this case the user is just authorized on a specific schema. On the other hand if GRANT is executed on CREATE SCHEMA, then that user can create procedure objects under any schema.
No he can't; he can only create procedures in schemas he creates, not in any others.
Tom