Marek: Created page with "CREATE TABLE problems: Insufficient privileges.

schema:scott

The user account must be set up to permit tables to be created. Usu..."

2012-07-17T09:22:35Z

Created page with "CREATE TABLE problems: Insufficient privileges. <div class='ht'> <div class=params>schema:scott</div> <div> The user account must be set up to permit tables to be created. Usu..."

New page

CREATE TABLE problems: Insufficient privileges.
<div class='ht'>
<div class=params>schema:scott</div>
<div>
The user account must be set up to permit tables to be created.
Usually the database administrator must grant such permissions.
</div>

<source lang=sql class='tidy'></source>
<source lang=sql class='setup'></source>

<source lang='sql' class='def'>GRANT CREATE ON d_db TO scott
</source>
<source lang='sql' class='def e-oracle'>GRANT RESOURCE TO scott
</source>

<div class="ecomm e-mysql" style="display: none">Users must be granted CREATE on the database.</div>
<div class="ecomm e-access" style="display: none">Make sure that the mdb file is not read only. You also may need write permission on the directory containing the mdb, this is because Access needs to create and ldb file.</div>
<div class="ecomm e-mysql" style="display: none">Users must be granted RESOURCE to create tables.</div>
</div>
{{CREATE and DROP ref}}

CREATE TABLE problems: Insufficient privileges. - Revision history

Marek: Created page with "CREATE TABLE problems: Insufficient privileges. schema:scott The user account must be set up to permit tables to be created. Usu..."

Marek: Created page with "CREATE TABLE problems: Insufficient privileges.

schema:scott

The user account must be set up to permit tables to be created. Usu..."