Hello all,
I'm having a bit of trouble securing my SQL Server 2000 database.
I have a windows group set up, and this can view one database only using an application role.

Any other databases I have created , the users cant access and this works fine.
However , the system databases , can be accessed.
eg. the user can enter the 'master' database and view data etc..

In the 'master' database , in the users section , the only users listed are dbo and guest.

I have a feeling its something to do with the Public role , but I aint sure how to correct the problem.

If anybody has any idea , let me know.

cheers