Database Sharing / Security

[ardagh]

I wish to secure a database and share it across a network, allowing different users different access permissions. I have tried to follow the advice from the Microsoft website on this topic but have found it very confusing.

One of the problems I have encountered is that the security seems to be inherited by every database on the computer. I only wish one to have security.

If anyone can simplify the sharing process for me and solve the above issue I would be grateful.

Regards
Niall

 

[PHV]

the security seems to be inherited by every database
Unless you only play with system.mdw, each database in a computer may have its own .mdw file.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[psemianonymous]

I have answered this question before, it's a common fallacy. Check this thread for someone who has done the exact same thing you did:

thread181-872286