PDA

View Full Version : Permission to add index to SQL table



Tod Brannen
10-Jun-2005, 04:14 PM
Greetings,
VDF 11.0
I am getting denied permission to add an index to a SQL table using the
DAW Sql CK. It is the same login I used to connect to the table. I thought
that indexes were like mods to the DDs and were only done on the Dataflex
side. I am only wanting to use this index to report on the file and not
change it. I don't think anyone can modify the database except the software
package that it is used with. (it is a commercial package). Is there any way
to do this?

Thanks,

Tod Brannen

Tod Brannen
10-Jun-2005, 04:22 PM
Adding an index should only change the INT file right, not the actual SQL
table??

Tod Brannen

Knut Sparhell
10-Jun-2005, 08:12 PM
Tod Brannen wrote:
> Adding an index should only change the INT file right, not the actual SQL
> table??

Not right. Indexes are part of a MS SQL table, or any DB table and are
maintained by the SQL Server engine. The indexes in SQL have names, and
must be referred to by their name. Therefore the .int file have to map
the DataFlex index numbers to index names. The FIELD INDEX is also a
DataFlex concept and thus have to reside in the .int file.

--
Knut Sparhell, Norway

Knut Sparhell
10-Jun-2005, 08:31 PM
Tod Brannen wrote:

> I am getting denied permission to add an index to a SQL table using the
> DAW Sql CK. It is the same login I used to connect to the table.

I guess you have to have the db_owner role associated with your user and
database to be able to add indexes to a table.

> I don't think anyone can modify the database except the software
> package that it is used with. (it is a commercial package). Is there any way
> to do this?

As a (SQL Server) system or server administrator you may do whatever you
want. Get hold of either the sa password or the user/password of a
member of the Adminstrators group (if using Windows Integrated access).
You may then use this access directly, or better, add db_owner role to
your user for this database.

--
Knut Sparhell, Norway

Ben Weijers
11-Jun-2005, 03:10 PM
Tod,

Indexes are part of a table's structure and are defined on the back-end. It
is possible to define an index in the intermediate file but you will
probably see poor performance if you do so. If you want to define indexes
this way you must use the intermediate file keywords: Index_Number,
Index_Number_Segments and Index_Segment_Field. You could also ask the DBA to
add the index for you.

Regards,

Ben Weijers
Data Access Wordlwide

Tod Brannen
13-Jun-2005, 03:02 PM
Knut, Ben,
Thanks for the clarification. I will see what I can do without getting
the third party upset. Also, I don't want to get blamed if something goes
wrong with the data.

Tod Brannen

"Ben Weijers" <ben.weijers@dataaccess.nl> wrote in message
news:R##BSGsbFHA.1436@dacmail.dataaccess.com...
> Tod,
>
> Indexes are part of a table's structure and are defined on the back-end.
It
> is possible to define an index in the intermediate file but you will
> probably see poor performance if you do so. If you want to define indexes
> this way you must use the intermediate file keywords: Index_Number,
> Index_Number_Segments and Index_Segment_Field. You could also ask the DBA
to
> add the index for you.
>
> Regards,
>
> Ben Weijers
> Data Access Wordlwide
>
>