• 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