Friday, March 23, 2012

Grant create stored procedure in a specific schema

I want to let my developers to create/alter stored procedure only under a
specific schema. which role let the login create a procedure , or Which role
let the login make ddl changes only in on schema (not in the dbo schema)Gal
Create a login with schema (give a mane) as a default . Those users will
connect with this login
"" <@.discussions.microsoft.com> wrote in message
news:1FD9FD0F-097C-4B3C-9E07-48D0D1AB4D87@.microsoft.com...
>I want to let my developers to create/alter stored procedure only under a
> specific schema. which role let the login create a procedure , or Which
> role
> let the login make ddl changes only in on schema (not in the dbo schema)

No comments:

Post a Comment