Unanswered: SQL2000 & master db permissions to end users
Hi all ,
We just installed new server and noticed this strange problem .
Here is the senario .
I created new db then new user to that db(with dbo permission to that db)
All working fine but i tested it from another machine and noticed that
the user can get access to the master db as well eventought he doesnt have permmission to it(doesnt sound right that db users will see the master contents)
Anyhow i treid allso to add the user to master then marked the deny read and write but then the user cant access at all , the error is something with
no access to sys_charset master table , so every user need read access for few tables from the master db but cant it be blocked from viewing via enterprise manager