<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head profile="http://internetalchemy.org/2003/02/profile">
<link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" />
<link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" />
<meta name="dc.title" content="Function: REPL_REVOKE - Virtuoso Functions Guide" />
<meta name="dc.subject" content="Function: REPL_REVOKE - Virtuoso Functions Guide" />
<meta name="dc.creator" content="OpenLink Software Documentation Team ; " />
<meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" />
<link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" />
<link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" />
<link rel="parent" href="functions.html" title="Chapter Contents" />
<link rel="prev" href="appendixa.html" title="Appendix" />
<link rel="next" href="functions.html#.html" title="" />
<link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" href="doc.css" />
<link rel="stylesheet" type="text/css" href="/doc/translation.css" />
<title>Function: REPL_REVOKE - Virtuoso Functions Guide</title>
<meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
<meta name="author" content="OpenLink Software Documentation Team ; " />
<meta name="copyright" content="OpenLink Software, 1999 - 2009" />
<meta name="keywords" content="" />
<meta name="GENERATOR" content="OpenLink XSLT Team" />
</head>
<body>
<div id="header">
<a name="fn_repl_revoke" />
<img src="../images/misc/logo.jpg" alt="" />
<h1>22. Virtuoso Functions Guide - REPL_REVOKE</h1>
</div>
<div id="navbartop">
<div>
<a class="link" href="functions.html">Chapter Contents</a> | <a class="link" href="fn_repl_pub_remove.html" title="REPL_PUB_REMOVE">Prev</a> | <a class="link" href="fn_repl_sched_init.html" title="REPL_SCHED_INIT">Next</a>
</div>
</div>
<div id="currenttoc">
<form method="post" action="/doc/adv_search.vspx">
<div class="search">Keyword Search: <br />
<input type="text" name="q" /> <input type="submit" name="go" value="Go" />
</div>
</form>
<div>
<a href="http://www.openlinksw.com/">www.openlinksw.com</a>
</div>
<div>
<a href="http://docs.openlinksw.com/">docs.openlinksw.com</a>
</div>
<br />
<div>
<a href="index.html">Book Home</a>
</div>
<br />
<div>
<a href="contents.html">Contents</a>
</div>
<div>
<a href="preface.html">Preface</a>
</div>
<br />
<div>
<a class="selected" href="functions.html">Virtuoso Functions Guide</a>
</div>
<br />
<div>
<a href="functions.html#admin">Administration</a>
</div>
<div>
<a href="functions.html#aggr">Aggregate Functions</a>
</div>
<div>
<a href="functions.html#array">Array Manipulation</a>
</div>
<div>
<a href="functions.html#bpel">BPEL APIs</a>
</div>
<div>
<a href="functions.html#backup">Backup</a>
</div>
<div>
<a href="functions.html#compression">Compression</a>
</div>
<div>
<a href="functions.html#cursors">Cursor</a>
</div>
<div>
<a href="functions.html#time">Date & Time Manipulation</a>
</div>
<div>
<a href="functions.html#debug">Debug</a>
</div>
<div>
<a href="functions.html#dict">Dictionary Manipulation</a>
</div>
<div>
<a href="functions.html#encoding">Encoding & Decoding</a>
</div>
<div>
<a href="functions.html#file">File Manipulation</a>
</div>
<div>
<a href="functions.html#ft">Free Text</a>
</div>
<div>
<a href="functions.html#hash">Hashing / Cryptographic</a>
</div>
<div>
<a href="functions.html#ldap">LDAP</a>
</div>
<div>
<a href="functions.html#localization">Locale</a>
</div>
<div>
<a href="functions.html#mail">Mail</a>
</div>
<div>
<a href="functions.html#misc">Miscellaneous</a>
</div>
<div>
<a href="functions.html#number">Number</a>
</div>
<div>
<a href="functions.html#phrz">Phrases</a>
</div>
<div>
<a href="functions.html#rdf">RDF data</a>
</div>
<div>
<a href="functions.html#rmt">Remote SQL Data Source</a>
</div>
<div>
<a class="selected" href="functions.html#repl">Replication</a>
</div>
<div class="selected">
<div>
<a href="fn_rdf_repl_graph_del.html">rdf_repl_graph_del</a>
</div>
<div>
<a href="fn_rdf_repl_graph_ins.html">rdf_repl_graph_ins</a>
</div>
<div>
<a href="fn_rdf_repl_start.html">rdf_repl_start</a>
</div>
<div>
<a href="fn_REPL_ADD_CR.html">repl_add_cr</a>
</div>
<div>
<a href="fn_REPL_ADD_DAV_CR.html">repl_add_dav_cr</a>
</div>
<div>
<a href="fn_REPL_ADD_SNAPSHOT_CR.html">repl_add_snapshot_cr</a>
</div>
<div>
<a href="fn_REPL_CREATE_SNAPSHOT_PUB.html">repl_create_snapshot...</a>
</div>
<div>
<a href="fn_REPL_CREATE_SNAPSHOT_SUB.html">repl_create_snapshot...</a>
</div>
<div>
<a href="fn_REPL_DROP_SNAPSHOT_PUB.html">repl_drop_snapshot_p...</a>
</div>
<div>
<a href="fn_REPL_DROP_SNAPSHOT_SUB.html">repl_drop_snapshot_s...</a>
</div>
<div>
<a href="fn_repl_grant.html">repl_grant</a>
</div>
<div>
<a href="fn_repl_init_copy.html">repl_init_copy</a>
</div>
<div>
<a href="fn_REPL_INIT_SNAPSHOT.html">repl_init_snapshot</a>
</div>
<div>
<a href="fn_repl_publish.html">repl_publish</a>
</div>
<div>
<a href="fn_repl_pub_add.html">repl_pub_add</a>
</div>
<div>
<a href="fn_repl_pub_init_image.html">repl_pub_init_image</a>
</div>
<div>
<a href="fn_repl_pub_remove.html">repl_pub_remove</a>
</div>
<div>
<a class="selected" href="fn_repl_revoke.html">repl_revoke</a>
</div>
<div>
<a href="fn_repl_sched_init.html">repl_sched_init</a>
</div>
<div>
<a href="fn_repl_server.html">repl_server</a>
</div>
<div>
<a href="fn_REPL_SERVER_NAME.html">repl_server_name</a>
</div>
<div>
<a href="fn_REPL_SNP_SERVER.html">repl_snp_server</a>
</div>
<div>
<a href="fn_repl_stat.html">repl_stat</a>
</div>
<div>
<a href="fn_repl_subscribe.html">repl_subscribe</a>
</div>
<div>
<a href="fn_repl_unpublish.html">repl_unpublish</a>
</div>
<div>
<a href="fn_repl_unsubscribe.html">repl_unsubscribe</a>
</div>
<div>
<a href="fn_REPL_UPDATE_SNAPSHOT.html">repl_update_snapshot</a>
</div>
<div>
<a href="fn_repl_disconnect.html">repl_disconnect</a>
</div>
<div>
<a href="fn_repl_new_log.html">repl_new_log</a>
</div>
<div>
<a href="fn_repl_purge.html">repl_purge</a>
</div>
<div>
<a href="fn_repl_server_rename.html">repl_server_rename</a>
</div>
<div>
<a href="fn_repl_status.html">repl_status</a>
</div>
<div>
<a href="fn_repl_sync.html">repl_sync</a>
</div>
<div>
<a href="fn_repl_sync_all.html">repl_sync_all</a>
</div>
<div>
<a href="fn_repl_text.html">repl_text</a>
</div>
<div>
<a href="fn_repl_this_server.html">repl_this_server</a>
</div>
<div>
<a href="fn_sub_schedule.html">sub_schedule</a>
</div>
</div>
<div>
<a href="functions.html#soap">SOAP</a>
</div>
<div>
<a href="functions.html#sql">SQL</a>
</div>
<div>
<a href="functions.html#string">String</a>
</div>
<div>
<a href="functions.html#txn">Transaction</a>
</div>
<div>
<a href="functions.html#type">Type Mapping</a>
</div>
<div>
<a href="functions.html#uddi">UDDI</a>
</div>
<div>
<a href="functions.html#udt">User Defined Types & The CLR</a>
</div>
<div>
<a href="functions.html#vad">VAD</a>
</div>
<div>
<a href="functions.html#jvmpl">Virtuoso Java PL API</a>
</div>
<div>
<a href="functions.html#bif">Virtuoso Server Extension Interface (VSEI)</a>
</div>
<div>
<a href="functions.html#ws">Web & Internet</a>
</div>
<div>
<a href="functions.html#xml">XML</a>
</div>
<div>
<a href="functions.html#XPATH">XPATH & XQUERY</a>
</div>
<br />
<div>
<a href="functionidx.html">Functions Index</a>
</div>
<br />
</div>
<div id="text">
<h2>REPL_REVOKE</h2>
<div class="refpurpose">revoke privileges for subscription</div>
<div class="funcsynopsis">
<span class="funcdef">
<span class="function">REPL_REVOKE</span>
</span>
(<span class="paramdef">in <span class="parameter">publication</span> varchar</span>,
<span class="paramdef">in <span class="parameter">grantee</span> varchar</span>);
</div>
<div class="refsect1">
<div class="refsect1title">Description</div>
<p>Revokes Privileges for Subscription. This is called on the publisher to
revoke access to the publication from the user account on the publisher.
The subscriber will no longer gain access to the publication with this account.</p>
</div>
<div class="refsect1">
<div class="refsect1title">Parameters</div>
<div class="refsect2">
<span class="refsect2title">publication – </span>
The publication name.
</div>
<div class="refsect2">
<span class="refsect2title">grantee – </span>
A valid DB account name to be refused subscription rights.
<div class="note">
<div class="notetitle">Note:</div>
<p>The DBA account is granted subscription rights by default,
which cannot be revoked.</p>
</div>
</div>
</div>
<div class="refsect1">
<div class="refsect1title">Example</div>
<a name="ex_repl_revoke_1" />
<div class="example">
<div class="exampletitle">Access to 'table_publication' removal for SQL user account 'demo'.</div>
<p>This is to remove permissions to subscribe from SQL user account 'demo' for table_publication publication account.</p>
<div>
<pre class="screen">
SQL> DB.DBA.REPL_REVOKE ('table_publication', 'demo');
</pre>
</div>
</div>
</div>
<div class="refsect1">
<div class="refsect1title">See Also</div>
<p>
<a href="fn_sub_schedule.html">sub_schedule()</a>
</p>
<p>
<a href="fn_repl_disconnect.html">repl_disconnect()</a>
</p>
<p>
<a href="fn_repl_grant.html">repl_grant()</a>
</p>
<p>
<a href="fn_repl_init_copy.html">repl_init_copy()</a>
</p>
<p>
<a href="fn_repl_new_log.html">repl_new_log()</a>
</p>
<p>
<a href="fn_repl_pub_add.html">repl_pub_add()</a>
</p>
<p>
<a href="fn_repl_pub_init_image.html">repl_pub_init_image()</a>
</p>
<p>
<a href="fn_repl_pub_remove.html">repl_pub_remove()</a>
</p>
<p>
<a href="fn_repl_publish.html">repl_publish()</a>
</p>
<p>
<a href="fn_repl_sched_init.html">repl_sched_init()</a>
</p>
<p>
<a href="fn_repl_server.html">repl_server()</a>
</p>
<p>
<a href="fn_repl_server_rename.html">repl_server_rename()</a>
</p>
<p>
<a href="fn_repl_stat.html">repl_stat()</a>
</p>
<p>
<a href="fn_repl_status.html">repl_status()</a>
</p>
<p>
<a href="fn_repl_subscribe.html">repl_subscribe()</a>
</p>
<p>
<a href="fn_repl_sync.html">repl_sync()</a>
</p>
<p>
<a href="fn_repl_sync_all.html">repl_sync_all()</a>
</p>
<p>
<a href="fn_repl_text.html">repl_text()</a>
</p>
<p>
<a href="fn_repl_this_server.html">repl_this_server()</a>
</p>
<p>
<a href="fn_repl_unpublish.html">repl_unpublish()</a>
</p>
<p>
<a href="fn_repl_unsubscribe.html">repl_unsubscribe()</a>
</p>
</div>
</div>
<div id="footer">
<div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div>
<div id="validation">
<a href="http://validator.w3.org/check/referer">
<img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" />
</a>
<a href="http://jigsaw.w3.org/css-validator/">
<img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" />
</a>
</div>
</div>
</body>
</html>
distrib
>
Fedora
>
14
>
x86_64
>
media
>
updates
>
by-pkgid
>
71d40963b505df4524269198e237b3e3
>
files
>
493
