April 13, 2008 at 12:11 am
hi ,
i have to give access to a user so that he can set up dts package and push in data to my sql server. i created a login for him and gave him the necessary permissions. now i do not want him to see any of my system d/bs eg. i do not want him to see any of the tables in the amster d/b nor modify them how do i set this thing up. if i give denydatareader role to master i can not login with the user name that i created.
thanks for the help.
April 13, 2008 at 1:03 am
In SQL Server 2000 there's not a whole lot you can do with respect to seeing information in the master database. The reason is that all users (except members of the sysadmin fixed server role) map in as guest, unless you explicitly grant them a login. Guest is a member of public (all users are) and public has the ability to view all the tables and read from most of them (at least, in the master database). This was by design, although SQL Sever 2005 tightens this up quite a bit. So you don't have a lot of options here if you wish to maintain a supported platform.
With respect to writing to the tables in the master database, what write access does the user have? Or a better question is how have you give the user access currently?
Msdb is a bit of a different animal in that guest can be disabled as a user (you can't do it for master). Again, this goes back to what access have you granted thus far?
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply