Re: HELP: Can a user create indexes in database

From: Hakan Eren <sarisin_at_interlog.com>
Date: 1997/06/21
Message-ID: <33AB5342.5405@interlog.com>#1/1

Aleksandr Vinokur wrote:
>
> Can a regular user create an index in the database or should only DBA ?

If you would like to create an index, the following conditions must be satisfied:

.. Must be in your schema (table or cluster)
.. Must have INDEX privilege on the table
.. Must have CREATE ANY INDEX system privilege.

Hakan Eren
InfoPower International Inc.
ERP/MRPII/DBMS Consulting and Software

Phone:905-507-2100
Fax:905-507-2108
E-mail:hakan_at_infopwr.com

prabir_at_infopwr.com Received on Sat Jun 21 1997 - 00:00:00 CDT