Histórico da Página

<div id="main-content" class="wiki-content group">
	<h2 id="ConfiguraçãodobancodedadosOracle-VersõeshomologadasdoOracle">Approved
		versions of Oracle</h2>
	<p>
		To see the approved versions of Oracle, access the&#160;<a
			href="httphttps://tdn.totvs.com/display/fluigeng/Array+of+portabilityx/yzASCw">Array of portability</a>
	</p>
	<h2 id="ConfiguraçãodobancodedadosOracle-Configuraçãodobanco">Data
		Bank configuration</h2>
	<p>
		The administrator of the Oracle® database (DBA) must make some
		security changes to the Oracle® database, causing the user (schema)
		informed in the TOTVS Fluig Platform installation not to have permission to
		read/change in other schemas in the Oracle® database, if any.<br />Only
		the schema used by Fluig should have permission to read/change.
	</p>
	<h2
		id="ConfiguraçãodobancodedadosOracle-Criaçãodousuárioeconcessãodeprivilégios">Create
		user and grant privileges</h2>
	<p>
		For the creation of a new user in Oracle database, we will&#160;<span
			style="color: rgb(29, 32, 33);">use the instruction CREATE
			USER, according to the syntax below:</span>
	</p>
	<div class="code panel pdl" style="border-width: 1px;">
		<div class="codeContent panelContent pdl">
			<pre class="theme: Confluence; brush: sql; gutter: false"
				style="font-size: 12px;">CREATE USER userid IDENTIFIED BY password [DEFAULT TABLESPACE tablespace] [TEMPORARY TABLESPACE tablespace_temporaria];</pre>
		</div>
	</div>
	<p>
		<span style="color: rgb(29, 32, 33);">Where:</span>
	</p>
	<ul>
		<li><strong style="font-size: 10.0pt; line-height: 13.0pt;">userid:</strong><span
			style="font-size: 10.0pt; line-height: 13.0pt;">&#160;Name of
				user to be created;</span></li>
		<li><strong style="font-size: 10.0pt; line-height: 13.0pt;">password:</strong><span
			style="font-size: 10.0pt; line-height: 13.0pt;">&#160;Password
				of user to be created;</span></li>
		<li><strong style="font-size: 10.0pt; line-height: 13.0pt;">tablespace
				(optional):</strong><span style="font-size: 10.0pt; line-height: 13.0pt;">&#160;Default
				tablespace where objects in the data bank will be stored. If this
				option is omitted, Oracle assumes the default SYSTEM tablespace;</span></li>
		<li><strong style="font-size: 10.0pt; line-height: 13.0pt;">temp_tablespace
				(optional):</strong><span style="font-size: 10.0pt; line-height: 13.0pt;">&#160;Default
				tablespace where temporary objects are stored, such as temporary
				tables. If this option is omitted, Oracle assumes a default TEMP
				tablespace;</span></li>
	</ul>
	<p>
		<span style="font-size: 10.0pt; line-height: 13.0pt;">After the
			user is created, it needs to be granted system privileges (DLL
			connections and instructions, for example) required for this user,
			according to the syntax below:</span>
	</p>
	<div class="code panel pdl" style="border-width: 1px;">
		<div class="codeContent panelContent pdl">
			<pre class="theme: Confluence; brush: sql; gutter: false"
				style="font-size: 12px;">GRANT CONNECT,RESOURCE TO userid;</pre>
		</div>
	</div>
	<p>
		<span style="color: rgb(29, 32, 33);">Where:</span>
	</p>
	<ul>
		<li><strong>userid:</strong><span>&#160;Name of previously
				created user;</span></li>
	</ul>
</div>