title: Oracle database links to grant/revoke roles
body: <p>I have a question about how to use database links in Oracle PL/SQL.  Let's say I have a database link (Database2) created in my current database, and I am using it to access a second database.  For example:</p>
  
  <pre><code>select *from CustomerTable@Database2;
  
  Update CustomerTable@Database2
  set Comment = 'Hello world!'
  where CustomerID = 123;
  </code></pre>
  
  <p>These all work successfully.</p>
  
  <p>But let's say I want to grant roles to or revoke roles from a user in Database2.  Can that be done through my database link?  If so, what is the syntax?</p>
  
  <p>If I open a PL/SQL session in Database2, then the syntax would be:</p>
  
  <pre><code>REVOKE some_role FROM bsmith;
  
  GRANT some_other_role TO rjones;
  </code></pre>
  
  <p>Is there any way to do this from my original database using my database link?</p>