apc.htm

Teach yourself Oracle8 in 21 day

	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>CREATE TYPE BODY</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">The <TT>CREATE TYPE</TT> system privilege is required for your own schema. The <TT>CREATE
			ANY TYPE</TT> system privilege is required for other schemas.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>CREATE USER</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>CREATE USER</TT>.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>CREATE VIEW</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">The <TT>CREATE VIEW</TT> system privilege is required for your own schema. The <TT>CREATE
			ANY VIEW</TT> system privilege is required for other schemas.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DELETE</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DELETE</TT>.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP CLUSTER</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">The <TT>DROP ANY CLUSTER</TT> system privilege is required, or the cluster must be
			in your own schema.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP DATABASE LINK</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">To drop your own database link, it must be in your own schema. To drop a public database
			link, you must have the <TT>DROP PUBLIC DATABASE LINK</TT> system privilege.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP DIRECTORY</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP ANY DIRECTORY</TT>.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP FUNCTION</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP ANY PROCEDURE</TT>.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP INDEX</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">The <TT>DROP ANY INDEX</TT> system privilege is required, or the index must be in
			your own schema.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP LIBRARY</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP LIBRARY</TT>.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP PACKAGE</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP ANY PROCEDURE</TT>.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP PROCEDURE</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP ANY PROCEDURE</TT>.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP PROFILE</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP PROFILE</TT>.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP ROLE</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">The <TT>DROP ANY ROLE</TT> system privilege is required, or you must have been granted
			the role with the <TT>ADMIN</TT> option.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP ROLLBACK SEGMENT</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP ROLLBACK SEGMENT</TT>.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP SEQUENCE</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">The <TT>DROP ANY SEQUENCE</TT> system privilege is required, or the sequence must
			be in your own schema.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP SNAPSHOT</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">The snapshot must be in your own schema, or the <TT>DROP ANY SNAPSHOT</TT> system
			privilege is required.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP SNAPSHOT LOG</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">The <TT>DROP ANY TABLE</TT> system privilege is required, or the table must be in
			your own schema.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP SYNONYM (PRIVATE)</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>SYNONYM</TT> must be in your own schema, or you must have the <TT>DROP ANY SYNONYM</TT>
			system privilege.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP SYNONYM (PUBLIC)</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>SYNONYM</TT> must be in your own schema, or you must have the <TT>DROP ANY PUBLIC
			SYNONYM</TT> system privilege.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP TABLE</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">The <TT>DROP ANY TABLE</TT> system privilege is required, or the table must be in
			your own schema.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP TABLESPACE</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP TABLESPACE</TT>.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP TRIGGER</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">The <TT>DROP ANY TRIGGER</TT> system privilege is required, or the trigger must be
			in your own schema.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP TYPE</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">The <TT>DROP ANY TYPE</TT> system privilege is required, or you must be in your own
			schema.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP TYPE BODY</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">The object <TT>TYPE BODY </TT>must be in your own schema and you must have the <TT>CREATE
			TYPE</TT> or <TT>CREATE ANY TYPE</TT> system privilege or the <TT>DROP ANY TYPE</TT>
			system privilege.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP USER</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP USER</TT>.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DROP VIEW</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">The <TT>DROP ANY VIEW</TT> system privilege is required, or the view must be in your
			own schema.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>GRANT</TT> (<TT>SYSTEM</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">To grant a system privilege you must have <TT>GRANT ANY</TT></TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>PRIVILEGES</TT> and <TT>ROLES</TT>)</TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>PRIVILEGE</TT> system privilege or you must have been granted the system privilege
			with the <TT>ADMIN OPTION</TT>. To grant a role you must have <TT>GRANT ANY ROLE</TT>
			system privileges, you must have been granted the role with the <TT>ADMIN OPTION</TT>,
			or you must have created the role.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>INSERT</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">This must be in your own schema, or you must have the <TT>INSERT</TT> system privilege
			on the table. To insert into any table, you must have the <TT>INSERT ANY TABLE</TT>
			system privilege.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>LOCK TABLE</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">The <TT>LOCK ANY TABLE</TT> system privilege is required, the table or view must
			be in your own schema, or you must have any object privilege on the table or view.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>NOAUDIT</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>AUDIT SYSTEM</TT>.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>(SQL Statements)</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"></TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>NOAUDIT</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">The <TT>AUDIT ANY</TT> system privilege is required or you must</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>(Schema Objects)</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">be in your own schema.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>RENAME</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">The object must be in your own schema.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>REVOKE</TT> (<TT>SYSTEM</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">To revoke a system privilege, you must have been granted</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>PRIVILEGES </TT>and <TT>ROLES</TT>)</TD>
		<TD ALIGN="LEFT" VALIGN="TOP">the system privilege or role with the <TT>ADMIN OPTION</TT>. To revoke a role, you
			must have <TT>GRANT ANY ROLE</TT> system privileges. To revoke a schema object privilege,
			you must have previously granted the object privileges to each user and role.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>ROLLBACK</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">To roll back the current transaction, no privileges are necessary. To roll back an
			in-doubt distributed transaction, the <TT>FORCE TRANSACTION</TT> system privilege
			is required. To roll back an in-doubt distributed transaction originally committed
			by another user, the <TT>FORCE ANY TRANSACTION</TT> system privilege is required.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>SAVEPOINT</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">None necessary.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>SELECT</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">This command requires that you have the <TT>SELECT</TT> system privilege on the appropriate
			table or snapshot or that you have the <TT>SELECT ANY TABLE</TT> system privilege
			for any table or snapshot.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>SET CONSTRAINT(S)</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">The <TT>SELECT</TT> system privilege on the table is required, or you must be in
			your own schema.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>SET ROLE</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">You must have already been granted the roles that you name in the <TT>SET ROLE</TT>
			statement.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>SET TRANSACTION</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">This must be the first statement in your transaction.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>TRUNCATE</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">The <TT>DELETE TABLE</TT> system privilege is required or the table or cluster must
			be in your schema.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>UPDATE</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">You must have <TT>UPDATE</TT> privileges on the appropriate table or base table or
			view.</TD>
	</TR>
</TABLE>

<H4><FONT COLOR="#000077"><B>Table C.2. Roles and their system privileges.</B></FONT></H4>
<P>
<TABLE BORDER="1">
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><B>Role</B></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><B>System privileges</B></TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>CONNECT</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>ALTER SESSION</TT>, <TT>CREATE CLUSTER</TT>, <TT>CREATE DATABASE LINK</TT>, <TT>CREATE
			SEQUENCE</TT>, <TT>CREATE SESSION</TT>, <TT>CREATE SYNONYM</TT>, <TT>CREATE TABLE</TT>,
			<TT>CREATE VIEW</TT>.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DBA</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP">All system privileges with <TT>ADMIN OPTION</TT>.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DELETE_CATALOG_ROLE</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>DELETE</TT> privileges on all dictionary packages for this role.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>EXECUTE_CATALOG_ROLE</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>EXECUTE</TT> privileges on all dictionary packages for this role.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>EXP_FULL_DATABASE</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>SELECT ANY TABLE</TT>, <TT>BACKUP ANY TABLE</TT>.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>IMP_FULL_DATABASE</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>BECOME USER</TT>.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>RESOURCE</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>CREATE CLUSTER</TT>, <TT>CREATE PROCEDURE</TT>, <TT>CREATE SEQUENCE</TT>, <TT>CREATE
			TABLE</TT>, <TT>CREATE TRIGGER</TT>.</TD>
	</TR>
	<TR ALIGN="LEFT" rowspan="1">
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>SELECT_CATALOG_ROLE</TT></TD>
		<TD ALIGN="LEFT" VALIGN="TOP"><TT>SELECT</TT> privileges on all catalog tables and views for this role.</TD>
	</TR>
</TABLE>
</P>
<CENTER>
<P>
<HR>
<A HREF="../apb/apb.htm"><IMG SRC="../buttonart/previous.gif" WIDTH="128" HEIGHT="28"
ALIGN="BOTTOM" ALT="Previous chapter" BORDER="0"></A><A HREF="../apd/apd.htm"><IMG
SRC="../buttonart/next.gif" WIDTH="128" HEIGHT="28" ALIGN="BOTTOM" ALT="Next chapter"
BORDER="0"></A><A HREF="../index.htm"><IMG SRC="../buttonart/contents.gif" WIDTH="128"
HEIGHT="28" ALIGN="BOTTOM" ALT="Contents" BORDER="0"></A> <BR>
<BR>
<BR>
<IMG SRC="../buttonart/corp.gif" WIDTH="284" HEIGHT="45" ALIGN="BOTTOM" ALT="Macmillan Computer Publishing USA"
BORDER="0"></P>

<P>&#169; <A HREF="../copy.htm">Copyright</A>, Macmillan Computer Publishing. All
rights reserved.
</CENTER>


</BODY>

</HTML>