title: Move Tables & Revoke All Privileges
body: <p>We need users to move their tables from their personal schemas (user_db.username) to the managed schema (userdb.groupname) which provides a predefined set of permissions for select access. In moving the table, we need to accomplish the following:</p>
  
  <ol>
  <li>Move the table out of the old schema </li>
  <li>Remove the old select grants</li>
  <li>Apply the new grants from the managed schema</li>
  </ol>
  
  <p>I've reviewed the Alter table .. rename to.. documentation, and while that appears to enable movement of the table, it would retain the old grants and not apply the new ones.  </p>
  
  <p>Is there an option or another way to do this in Snowflake SQL?</p>