Histórico da Página
HTML |
---|
<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 <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 <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;"> 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;"> 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;"> 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;"> 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> Name of previously created user;</span></li> </ul> </div> |
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas