topic Hiding database objects in the Create Select Statement dialog box in QlikView https://community.qlik.com/t5/QlikView/Hiding-database-objects-in-the-Create-Select-Statement-dialog/m-p/157483#M32938 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>In the QlikView (Personal Edition) Edit Script dialog box, I connect to an ODBC data source which is an Oracle database.<BR />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.<BR />I want to hide certain tables from the users and only display few users need.<BR />How can I hide these objects? Can it be done on a database level?</P><P>Thank you</P><P>Jozef</P></BODY></HTML> Thu, 19 Nov 2009 06:51:30 GMT 2009-11-19T06:51:30Z Hiding database objects in the Create Select Statement dialog box https://community.qlik.com/t5/QlikView/Hiding-database-objects-in-the-Create-Select-Statement-dialog/m-p/157483#M32938 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>In the QlikView (Personal Edition) Edit Script dialog box, I connect to an ODBC data source which is an Oracle database.<BR />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.<BR />I want to hide certain tables from the users and only display few users need.<BR />How can I hide these objects? Can it be done on a database level?</P><P>Thank you</P><P>Jozef</P></BODY></HTML> Thu, 19 Nov 2009 06:51:30 GMT https://community.qlik.com/t5/QlikView/Hiding-database-objects-in-the-Create-Select-Statement-dialog/m-p/157483#M32938 2009-11-19T06:51:30Z Hiding database objects in the Create Select Statement dialog box https://community.qlik.com/t5/QlikView/Hiding-database-objects-in-the-Create-Select-Statement-dialog/m-p/157484#M32939 <HTML><HEAD></HEAD><BODY><P>Hello Jozef,</P><P>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.</P></BODY></HTML> Thu, 19 Nov 2009 14:48:03 GMT https://community.qlik.com/t5/QlikView/Hiding-database-objects-in-the-Create-Select-Statement-dialog/m-p/157484#M32939 Miguel_Angel_Baeyens 2009-11-19T14:48:03Z Hiding database objects in the Create Select Statement dialog box https://community.qlik.com/t5/QlikView/Hiding-database-objects-in-the-Create-Select-Statement-dialog/m-p/157485#M32940 <HTML><HEAD></HEAD><BODY><P>Hi Miguel</P><P>Any ideas how this (hiding all the objects not owned by a user from the user) could be achieved on the database level?</P><P>Regards</P></BODY></HTML> Fri, 20 Nov 2009 06:51:45 GMT https://community.qlik.com/t5/QlikView/Hiding-database-objects-in-the-Create-Select-Statement-dialog/m-p/157485#M32940 2009-11-20T06:51:45Z Hiding database objects in the Create Select Statement dialog box https://community.qlik.com/t5/QlikView/Hiding-database-objects-in-the-Create-Select-Statement-dialog/m-p/157486#M32941 <HTML><HEAD></HEAD><BODY><P>Well, it depends very much on the DBMS, so I suggest you to read carefully your database documentation.</P></BODY></HTML> Sat, 21 Nov 2009 17:22:02 GMT https://community.qlik.com/t5/QlikView/Hiding-database-objects-in-the-Create-Select-Statement-dialog/m-p/157486#M32941 Miguel_Angel_Baeyens 2009-11-21T17:22:02Z