Results 1 to 3 of 3

Thread: Public Database Permissions

  1. 05-02-2007, 03:59 PM #1
    SeaChange
    SeaChange is offline Registered User
    Join Date
    May 2007
    Posts
    2

    Public Database Permissions

    I have a db that I use as the backend to an Access application. The application looks at 2 databases that are on the clinet machine. A db from a vendor and my new database. I can read the vendor db (with the proper dns), but I can only read my db when the user has admin privileges. I have granted the public all permissions for the table on my db. What am I missing?

    Also, this is a db on a Small business Server 2003 so all of the SQL tools do not appear to be there.

    TIA
    Reply With Quote Reply With Quote
  2. 05-03-2007, 07:40 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Did you add sql logins as db user in your db?
    Reply With Quote Reply With Quote
  3. 05-04-2007, 04:45 AM #3
    SeaChange
    SeaChange is offline Registered User
    Join Date
    May 2007
    Posts
    2

    Thanks

    Thank you for the insight. I added the SQL logins and added a role and that worked.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules