Re: Grant create stored procedure in a specific 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@xxxxxxxxxxxxxxxx
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)


.

Relevant Pages

  • user/schema problem in SQL Server 2005!
    ... 1:Use Manage Studio login the server with Integrated security. ... 2:Create a dabase named testdb; ... 4:Create a SQL Server login named guxiaobo,set it's default databse to ... 7:In database testdb create a schema schema1 owned by dbo; ...
    (comp.databases.ms-sqlserver)
  • Re: Default schema not working properly for AD groups
    ... CREATE SCHEMA test AUTHORIZATION ... CREATE LOGIN FROM WINDOWS; ... SQL Server MVP ... We are running SQL 2005 SP2. ...
    (microsoft.public.sqlserver.security)
  • Re: Change default Schema for a user automatically
    ... | Is there a way that I define, default Schema for a user automatically? ... | I have some users that login from different software and they have no data ... | command for user to make it run whenever it login to system? ... | program or Oracle clients). ...
    (comp.databases.oracle.server)
  • Change default Schema for a user automatically
    ... Is there a way that I define, default Schema for a user automatically? ... I have some users that login from different software and they have no data ... command for user to make it run whenever it login to system? ... I use Oracle 10G release 2.0 under widows Server 2003, ...
    (comp.databases.oracle.server)
  • Re: Default schema not working properly for AD groups
    ... CREATE LOGIN FROM WINDOWS; ... SQL Server MVP ... By deafult the objects are created with DBO schema. ...
    (microsoft.public.sqlserver.security)