Member Avatar for sunchica

I am creating a db that needs a very high security level. I have multiple users on the server, but I need to restrict the access to my db to only one of them. I tried setting the "Single User" option for my db, but then none of the users could access the db. I tried then deleting users, changing roles, etc. but nothing helped. Oh, this is my first serious db so I was a bit chaotic and random in my ideas, so help pleaseeee.....:)

  • 2 Contributors
  • 1 Reply
  • 42 Views
  • 16 Hours Discussion Span
  • Latest Post Latest Post by Ramy Mahrous
Member Avatar for Ramy Mahrous

grant all permissions to one of them and set for him/her username ana password
while connection to database use the username and the password for connecting

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.