Create Permission in Schema

  • Hi Friends,

    Iam having schema called "Reports" ,

    This reports schema having tables and stored procs ,but

    my question is

    I need to give create permission in this schema to particular user?

    for eg ;

    Schema : Reports

    User : Test

    Stroed procedure to be created : Addition

    How can i give create stored proc permission to user in this schema?

  • .

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • Grant CREATE PROC to a role. Add Users in that role.

    Grant ALTER SCHEMA on the schema(s) that the Users need to modify stored procedures in to the role.

    Grant VIEW DEFINITION on the schema(s) that the Users need to modify stored procedures in to the role.

    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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply