master and msdb database permissions

From: Randy (rgeater_at_nospam.com)
Date: 10/29/03 

Date: Wed, 29 Oct 2003 15:15:30 -0500

Stupid question, I'm sure this has been answered before, but I cannot find
anything about it........

Is it possible to revoke permissions to master and msdb databases? I have a
client that is asking that question. My instincts tell me that this cannot
be done, but I have bad instincts. Since a user is not given explicit
permissions to these databases, how would one revoke permissions if they can
be revoked?

When our script creates the login, and grants access to the application
database, the login created can login with QA and also see master and msdb
databases in the drop down list of databases, and can select from tables.
What permissions does a user have to these databases by default? SELECT,
INSERT, UPDATE, DELETE????? I need to help the client (and myself)
understand the level of risk associated with having access to these
databases. If there are online articles, or something in BOL that I can
look into, please advise.

Thanks!

Relevant Pages

  • Re: Systems Log file
    ... The master and msdb databases use the SIMPLE recovery model so you don't ... to backup the logs separately. ...
    (microsoft.public.sqlserver.programming)
  • Re: Please answer my queries for fresh Installation
    ... You can restore MSDB as well as master. ... > SQL Server, It will create Master, MSDB databases. ...
    (microsoft.public.sqlserver.server)
  • Re: Move databases between servers
    ... What I'm trying to do now is to copy master. ... Now I'm reinstalling sql with identical version, and restore all databases ... Since the logins are in master and operators/agents are in msdb why I ... copy all database and log files to new server ...
    (microsoft.public.sqlserver.setup)
  • Re: Move databases between servers
    ... Tell me why you need to move master, msdb, and model? ... When you restore databases on your other server SQL Server adds ... If you have lots of jobs defined you could try restoring MSDB. ...
    (microsoft.public.sqlserver.setup)
  • Re: Move Existing SQL Server to a New Server
    ... Restore master, then model, then msdb then the user ... databases during start up ... I do not want to move all user databases, ... > moving or restoring the databases - especially related to ...
    (microsoft.public.sqlserver.setup)