Grant ddl access to a schema

• pmaceke

  Ten Centuries

  Points: 1018

  More actions

  November 24, 2014 at 12:36 am

  #292389

  Hi,

  Please assist me. How do I grant a specific access to a schema. I have a request to grant a ddl access to a schema called Business_Banking.

  Thank you in advance.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734562

  More actions

  November 24, 2014 at 5:23 pm

  #1760668

  grant alter on the schema to a role and then grant create table/view/proc to the role.

  Add users to the role.