Home Forums SQL Server 2014 Administration - SQL Server 2014 GRANT User Permissions to Create, Drop Alter all Objects is a schema RE: GRANT User Permissions to Create, Drop Alter all Objects is a schema

  • September 28, 2016 at 6:51 pm

    #1903812

    GRANT CREATE PROCEDURE for User Canada on schema ca?

    GRANT CREATE PROCEDURE ON ::ca TO Canada WITH GRANT OPTION;

    I do not need the WITH GRANT Option.

    Does that look right?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/