System Tables seen in the Query Template table list.

[Former Member]

Hi,

I have a problem with a lot of tables being seen in the Table list in a SQL Query templates.

Connector: Sql Connector

Database: Sql Database on SQl server 2005

I open a SQL Query template, choose the conector and mode Fixed query. when I switch to the Fixed query tab i find a huge list of system tables views along with the tables in the database connector is pointing to.

This makes the developers task tough as he has to search for one or two tables in a list of 30 or 40 tables.

Many should have faced this problem. could you enlighten with the solution/work around.

Any help in this regard is appriciable.

Regards,

A Prashant Kiran

[Former Member · Accepted solution]

Don't use the database admin account or a high-priviledge database account credentials when connecting to the database.

[Former Member · Accepted solution]

Hi,

The login I use has select privilage nothing much.

i will try limiting the user and test it.

is there any thing else i need to check.

Regards,

A Prashant Kiran

[Former Member · Accepted solution]

I had the same problem and changining the rights to the user cured the issue.