February 2, 2008 at 4:27 am
I have created a new login and assinged a database to that login.
On opening the SQL Query Analyzer with that login I can access only that particular database, and none of the other user defined database can be opened with that database.But how can I access the master databasewith that login which I do not want. I even checked the Database Access properties of that login and only
that particular database has been checked. How can this happen and How can I make that login not to access master database.
February 2, 2008 at 6:18 am
Access to the master DB is required to a certain extent. What/why do you wish to deny (in) the master DB?
February 2, 2008 at 6:37 am
Let the login access any objects in the master database, but I do
not want the master database to be visible or opened in the query
analyzer to that login.
February 2, 2008 at 7:10 am
Hmmm... You could try to deny access to most of the tables in master I guess.
If you really want to go down that road (if they can view but not change is that not enough?) then I'd suggest that you
1. Start SQL Profiler
2. Log in to QA using the limited user
3. Get the limited user to view a thing or two they shouldn't
4. See what commands were issued by QA for that user. Explicitly deny access to the appropriate tables
I haven't seen someone do what you're trying to do. I'm not saying it's impossible but it may be tricky. Some access to master may be necessary to have things work at all.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply