title: Giving MANAGE GRANTS to a Role
body: <p>I am writing a procedure that is going to create objects (views) across multiple schemas where those views need to have different owners.  I want the procedure to GRANT OWNERSHIP to the appropriate role after it creates the view, but my newly created DEV_PROC_ROLE which is used to create and maintain procedures cannot execute GRANT OWNERSHIP.  Our higher level roles can, but I don't want the procedure to be managed and executed up at that level.</p>
  
  <p>Here's some context
  <a href="https://docs.snowflake.net/manuals/sql-reference/sql/grant-ownership.html" rel="nofollow noreferrer">https://docs.snowflake.net/manuals/sql-reference/sql/grant-ownership.html</a></p>
  
  <p><em>"A role that has the MANAGE GRANTS privilege can transfer ownership of an object to any role; in contrast, a role that does not have the MANAGE GRANTS privilege can only transfer ownership from itself to a child role within the role hierarchy."</em></p>
  
  <p>So what command do I need to execute in my higher level role to give the MANAGE GRANTS privilege to the DEV_PROC_ROLE?  </p>
  
  <p>I cannot find in the documentation how to grant the MANAGE GRANTS privilege to a role.</p>
  
  <p>Note - once the DEV_PROC_ROLE can grant ownership, it will issue a command like this to change the ownership and retain all of the Future Select priv's of other roles setup against that schema.  GRANT OWNERSHIP ON VIEW  TO ROLE  COPY CURRENT GRANTS;</p>