grant statements to create userdefined role.

• charipg

  SSCrazy Eights

  Points: 9888

  More actions

  May 11, 2015 at 4:43 pm

  #300446

  Need to create a user defined role with grant permissions for below .

   View Definition

   Execute all Function

   Grant View

   Grant Synonym

   dbo

   View Definition

  Not getting grant statements for above permissions.

  I mean like below.

  -----------------------------------------------------------------

  CREATE ROLE [Role1]

  GRANT EXECUTE ON SCHEMA ::dbo TO [Role1]

  -----------------------------------------------------------------

  Any help here .

• charipg

  SSCrazy Eights

  Points: 9888

  More actions

  May 11, 2015 at 5:14 pm

  #1797137

  I got for dbo(db_owner).

  ALTER AUTHORIZATION ON SCHEMA::[db_owner] TO [Role1]

  Any help for below grant permissions.

  View Definition

  ? Execute all Function

  ? Grant View

  ? Grant Synonym