Re: SEE Databases
From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 08/20/04
- Next message: Jasper Smith: "Re: Job fails due to domian acccont"
- Previous message: C TO: "Security Admin and Backup"
- In reply to: michelle: "SEE Databases"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 20 Aug 2004 17:43:42 -0400
michelle,
How are they seeing them? Through Enterprise Manager or through Query
Analyzer?
If I remember correctly, Enterprise Manager shows all databases, even those
to which you do not have rights. They will need to be able to connect to
the SQL Server, of course, even if only to the master database. No special
rights are needed.
Through Query Analyzer you can execute "sp_helpdb" which also offers status
information on the databases. Again, no special rights are needed. Check
out sp_helpdb in the BOL
Russell Fields
"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?
>
>
- Next message: Jasper Smith: "Re: Job fails due to domian acccont"
- Previous message: C TO: "Security Admin and Backup"
- In reply to: michelle: "SEE Databases"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
