Not displaying system dbs in EM

From: Jean Davis (jean_davis_200_at_hotmail.com)
Date: 07/07/05

  • Next message: spade: "Re: Users not visible in database's user folder" 
    Date: Thu, 7 Jul 2005 14:41:09 +0100

    Hi

    I've just run the updated sp_MSdbuseraccess SP so that users can only see
    databases listed in EM that they have access to but does anyone know of a
    way to update this so that the Master, MSDB and tempDB databases are not
    displayed as well?

    Thanks - Jean.

  • Next message: spade: "Re: Users not visible in database's user folder"

    Relevant Pages

    • Re: maintenance plan in enterprise manager not functioning quite right
      ... Well it can't issue a log backup on Master and MSDB since they are in simple ... > all dbs are set to recovery model full except for the master and msdb dbs. ...
      (microsoft.public.sqlserver.tools)
    • Re: MSDB and MASTER DB
      ... For these volumes I would use transactional replication if possible. ... In master your linked servers and logins live. ... Your msdb databsae ... Looking for a SQL Server replication book? ...
      (microsoft.public.sqlserver.replication)
    • Re: Master, Model, MSDB What Recovery Models
      ... Are you saying that that the Master and MSDB will always stay in simple ... > Model - matters little but it does set the default recovey model for new ... >> What Recovery Model and what Backup Type should be used on the Master, ...
      (microsoft.public.sqlserver.server)
    • Re: DB Maintenance Planner - Jobs not running
      ... All the jobs ran last night EXCEPT: ... MSDB db trans log backup / MSDB db Integrity Checks ... Master db trans log backup / Master db Integrity Checks ...
      (microsoft.public.sqlserver.tools)
    • Re: Master, Model, MSDB What Recovery Models
      ... You can have msdb in full recovery mode. ... I usually to log backups for msdb. ... I'd prefer an error message if I to set master to full. ...
      (microsoft.public.sqlserver.server)
    Loading