How to secure a Database in MsSql 2005 so that specificc user works with it

We would like to move a specific MsSql Database outside from its standard folder "C:\Program Files\Microsoft SQL Server\MSSQL\Data" to another folder within the PC.

    1. The SQL is in a PC, not a server.  
    2. The PC is used by different user login with their username (total of 5 users)
    3. All user uses MsSql doing queries and creating and working with their database
    4. One user is the one that has the Database we want secure so that the other \
        four user can't access it

Whats the best way doing this


. What we want is that one user have access to this specific folder
rayluvsAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
rawinnlnx9Connect With a Mentor Commented:
Set permissions on the folder that holds the .ldf and .mdf file. Then only allow the 1 user to have the appropriate access and remove all other access except system and network services.
0
 
rayluvsAuthor Commented:
let's try...
0
 
geek_vjCommented:
If you dont want other four users to access the database, then you have to provide permissions only to that user where you need the access. If you dont provide any exclusive access to other four users, then they cant access the database.

0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
samijsrConnect With a Mentor Commented:
You can do both,
Set the Permission to Particular folder where Data  file reside, by allowing only 1 particular user to have Permission and removel all others.

And you can also set the Permission using SQL Server Managment Studio to get Login on Particular Database by only 1 user and denie Permission other 4.
0
 
rayluvsAuthor Commented:
yup worked!
0
 
rayluvsAuthor Commented:
Gave rawinnlnx9 more points becuase his solution gave the exact results.  With the other, they recommended the giving access via studio when all my users can use studio and change this access.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.