title: Granting permission to users on different schema
body: <p>I have tables in Schema A. I created views in Schema B using the tables in schema A. </p>
  
  <p>I want to grant permissions to a user to select the data from view in Schema B. </p>
  
  <p>For this to work i know we have to enable the grant option on tables in Schema A to user B.
  But I want to do it in a single script (This script has to be in schema B). Is there a way to do this using the user name/password of schema A.</p>