Alpha Video Training
Results 1 to 2 of 2

Thread: Are QBES User Rights Supposed to be Enforced by QReportBuilder?

  1. #1
    Member
    Real Name
    Tom Little
    Join Date
    Nov 2007
    Posts
    6

    Default Are QBES User Rights Supposed to be Enforced by QReportBuilder?

    I have a user who has only the Sales role in QBES. The QODBC driver is set to use this users login to access QBES. When I refresh all the tables and then browse them via QReportBuilder I can see data in tables QBES will not let this user access (the Check table for instance). yet VBDemo does not return anything for this user when querying this table This user should not see the data in this table no matter what tool he is in. What gives?

    I am using QBES v8 with QODBC v8.00.00.240.

    TIA

    Tom

  2. #2
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,628

    Default Re: Are QBES User Rights Supposed to be Enforced by QReportBuilder?

    Tom

    The QBES data access rules are enforced. I would suggest that you look at the integrated applications form within QB to make sure that it is set properly and that the QODBC connection is using the proper user name to connect to QB.

    These settings would be the same for any other product accessing QB to provide the same security.

    You had mentioned to me off-board that you currently use Crystal. Crystal would require the same settings and would also require a connection to QB anytime that a report was generated.

    One of the advantages of QRB, is that the cached passive link tables require a connection to QB only to refresh. Reports can be run from the cache (or data mart - depending on your semantics) without a connection to QB.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

Similar Threads

  1. Welcome to the QReportBuilder Forum!
    By bradwww in forum QReportBuilder
    Replies: 15
    Last Post: 01-04-2008, 07:50 PM
  2. Custom menus based on User Rights
    By Classick in forum Alpha Five Version 6
    Replies: 4
    Last Post: 08-01-2006, 07:03 PM
  3. Client Login with limited user rights
    By Jared Sutherland in forum Web Application Server v6
    Replies: 4
    Last Post: 05-10-2005, 07:07 PM
  4. User Rights Required for Table Updating
    By Red Abicht in forum Alpha Five Version 4
    Replies: 1
    Last Post: 09-11-2003, 03:42 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •