Password for tables ??

Results 1 to 2 of 2

Thread: Password for tables ??

  1. #1 Guest

    Default Password for tables ??

    I want to create one database for 3 users.<BR>But I want they to have access(password) only to their table , co they can modify data in their table. But I want to show on Main page all records from database (from all 3 tables)<BR>Thanks in advance<BR>Zoran<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Password for tables ??

    Assuming you use MS SQL:<BR>create a login and password for your 3 users and give it<BR>datareader and datawriter privileges on the specific table of the database you want to give the 3 users access to.<BR>Then create a universal login for the database and give it only datareader privileges, so that you can use it to access (read-only) the database for everyone else.

Posting Permissions

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