Simon,
If you connect to the database as a user who does not have access to all data, you get only the data in QV application which this user can access. This is fine if this application will be used only by the same user and nobody else. Different user has access to the different subset of data, hence has to reload separately into his own copy of QV application.
If you want to have all data in one QV application, you must connect as a user with full access, admin or not. I'm using this approach because our applications for MS CRM are always QV Server-based, so one application is available for all users. In this case there is no advantage in using views.
Same as Stepfano - using windows authentication to connect to database.
