Results 1 to 4 of 4
  1. #1
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    A Security Question (A2K SR1)

    I have secured a database that allows users to Insert, Delete, Write, and update data in tables due to queries, macros, etc, that are executed. However, I do not want to the users to have the ability to see the tables. Is there a way to prevent the users from getting to the tables and reviewing the data there?
    Regards,

    Gary
    (It's been a while!)

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A Security Question (A2K SR1)

    The Security white paper document on Microsoft's site describes a technique called Read With Owner's Permission (RWOP) queries. In essence, you can deny everybody the ability to view the data in the tables, but still allow them to view/edit/update via predefined queries.

    http://support.microsoft.com/default.aspx?...b;EN-CA;q165009
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A Security Question (A2K SR1)

    Secure the tables so that they can't be opened by anyone other than somebody "special" (e.g. the designer). Then, you will need to make sure your queries are owned by that special person, and set their Run Permission (under View | Properties) to Owner's rather than User's.

    You'll then need to make sure all your forms, macros, etc. use the queries rather than the tables.

  4. #4
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: A Security Question (A2K SR1)

    Thanks for the link. The security white paper is extremely helpful.
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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