Page 1 of 1

To only return tables from the project of the the user

Posted: 01.12.2005, 06:41
by orlando
To some form of commando the ZConnection1.GetTableNames to only return the tables that using registered at the moment permission has to select ?? :roll:

Regards

Edmilson

Posted: 01.12.2005, 08:59
by zippo
Hmmm... Maybe I didn't understood well, so here's what I udnerstood:

You wand to show only the tables in a database that the user has privileges to SELECT?

Well, in this case you already done it. :) MySQL shows only the data that the user has privileged to SELECT. The same applies for databases, too.

Posted: 01.12.2005, 11:45
by orlando
Yes but if I use command GetTableName in a PostGre DataBase it I show to all tables same those that the user does not have right to make one select

Regards

Edmilson