Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002

    Talking Unanswered: Security Problem

    User who want to use my database need to login the system since I have made a workgroup file for the database. For example, a user called "tom" use the system. "tom" has right to edit/add/delete data of a table called customer.
    My question is how to allow him to edit/add/delete data by using my application but not allow him edit/add/delete data directly in the table?

  2. #2
    Join Date
    Aug 2002
    Charlotte NC


    Your question seems to have many diff answers, but they all have one thing in common. For a user to acess the data in the table and change it they have to have read/write acess. If you dont want them to open the table and edit it straight from there then you will have to build a form. Even if you used a view (ie a query that showed just the data that they need to edit) that user will still need read/write acess to the underlying table. I hope this helps. Regards
    And back to SQL Server....I always find my way home
    View my Linkedin profile

Posting Permissions

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