Re: Creating specific users
- From: "Russell Fields" <russellfields@xxxxxxxxxx>
- Date: Wed, 25 Apr 2007 12:06:09 -0400
Simon,
A user does not need to be sysadmin to run backups (such as through Query
Analyze as Uri mentioned), but I believe that Enterprise Manager for SQL
Server 2000 specifically checks for sysadmin in the application.
So, as long as SQL Server 2000 and Enterprise Manager are the tools, I think
you are stuck with this level of access. Perhaps your revised approach will
not be too far away.
RLF
"Simon" <Simon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:26A07029-860D-40FB-B382-B064819B3A04@xxxxxxxxxxxxxxxx
The whole backup regime was setup before I joined the company. They use
SQL
jobs to run the SQL backups onto tape. A user has been designated to check
EM
to ensure the tape contents are correct. This will change in the medium
term
as we are looking at how everything is backed up and will probably move to
something like Quest Litespeed. However in the short term I don`t really
want
to change the way things are done, only to change in the future.
"Uri Dimant" wrote:
Simon
Why do the users need to see the backups in EM? The files are located on
filesystem.
Can just users issue BACKUP DATABASE/RESTORE DATABASE... from QA?
"Simon" <Simon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1A221F70-5B21-4A76-97DF-4BF62A4E4196@xxxxxxxxxxxxxxxx
I have a user who is just responsible for monitoring SQL backups.
However I
seem to have to grant sys admin rights in order for the user to be able
to
see the backups in Enterprise manager. What is the lowest level that I
can
grant to the user in this situation ?
Si
.
- References:
- Re: Creating specific users
- From: Uri Dimant
- Re: Creating specific users
- Prev by Date: Re: Creating specific users
- Next by Date: Re: create\alter sp in schema privilage
- Previous by thread: Re: Creating specific users
- Next by thread: Re: Creating specific users
- Index(es):
Relevant Pages
|
