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