Chapter 3 DBMS Reference Guide

EnableOwner

Allows to define index owners. The index owner can be identical or different from the table owner.

Value Result
Yes The Owner dropdown listbox appears in the index property sheet and the user can select an owner for the current index
No Index does not support owner

Example

EnableOwner = YES

If you enable owner on indexes, you have to make sure the Create statement reflects this change in order to take into account the table and index owner. For example, in Oracle 9i, the Create statement of an index is the following:

create [%UNIQUE%?%UNIQUE% :[%INDEXTYPE% ]]index [%QUALIFIER%]%INDEX% on [%CLUSTER%?cluster C_%TABLE%:[%TABLQUALIFIER%]%TABLE% (
   %CIDXLIST%
)]
[%OPTIONS%]

Where %QUALIFIER% refers to the current object (index) and %TABLQUALIFIER% refers to the parent table of the index.

 

Copyright (C) 2005. Sybase Inc. All rights reserved.