Oracle database links to grant/revoke roles
<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>