Hiding database objects in the Create Select Statement dialog box

[#1]

Hi

In the QlikView (Personal Edition) Edit Script dialog box, I connect to an ODBC data source which is an Oracle database.
When I open the Create Select Statement dialog box in which I want to specify fields and tables from the chosen data source I see all the tables/views that have been granted to public.
I want to hide certain tables from the users and only display few users need.
How can I hide these objects? Can it be done on a database level?

Thank you

Jozef

[Miguel_Angel_Baeyens]

Hello Jozef,

I'd rather set the permissions in the database level, as it is a security matter regardless QlikView. When you connect with user and password, you will see all that user and password can see.

[#3]

Hi Miguel

Any ideas how this (hiding all the objects not owned by a user from the user) could be achieved on the database level?

Regards

[Miguel_Angel_Baeyens]

Well, it depends very much on the DBMS, so I suggest you to read carefully your database documentation.