Re: SEE Databases

From: michelle (michelle_at_nospam.com)
Date: 08/20/04 

Date: Fri, 20 Aug 2004 16:35:24 -0500

I believe that I have answered my own question. I was able to see all of the
databases simply with a valid login on the sql server (no server roles or
database permissions).

"michelle" <michelle@nospam.com> wrote in message
news:eASK3ZvhEHA.2952@TK2MSFTNGP09.phx.gbl...
> I need to grant permissions to our server administrators so that they can
> just 'see' the databases in order to verify after a reboot that none are
> marked suspect. What permissions do they need?
>
>

Relevant Pages

  • Re: Exchange Move Issues?
    ... I'm a bit confused on what permissions to assign for SBS, ... When you finish moving the databases, ... You can move the log files and database files to any folder that you want to ... Note Only assign permissions to the Server Operators group if the Exchange ...
    (microsoft.public.windows.server.sbs)
  • Re: How to move system databases to new SAN drive in cluster serve
    ... I have moved model, msdb, and tempdb on a cluster ... Moving SQL Server databases to a new location with Detach/Attach ...
    (microsoft.public.sqlserver.clustering)
  • Re: Migrate stand alone sql server to a cluster without downtime
    ... Use backup and restore to create the databases on the new system. ... Run a log backup WITH STANDBY on each database on the old server. ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: SPS 2003 Portal change SQL server
    ... select portal site to delete and choose to NOT delete the databases ... server farm, you can just copy them over. ... attach the databases to the new sql server. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: AS2005 ... what is wrong with it?
    ... What I have seen is that the dev server is *faster* than the prod server ... And does your dev server also have all 6 databases with all these roles? ... When I restore the "PROV" i got approx 20 sec. ... Starting from an empty data folder should show if this theory is true ...
    (microsoft.public.sqlserver.olap)