Member Avatar for ggaudreau

Hi all,

My server will have multiple databases and I want, for security purpose, to have one user per database. This user will only be able to access that one table and no other. This user will have all rights to this database only.

I created my first database/user combo and it seems to work, however, when I go to the second table/user the new user can no longer access the newly created database.

The user I want to create is going to authenticate only to the SQL server not to Windows.

User Database
joe joe_db
paul paul_db
john John_db

P.S. The user will have full rights to its database and none to anyone else's


Thank you in advance!

  • 1 Contributor
  • 1 Reply
  • 70 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by ggaudreau
Member Avatar for ggaudreau

P.S. I want toi use the GUI to create the users.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.