Re: sp_detach_db when not using a system administrator role
- From: "Arnie Rowland" <arnie@xxxxxxxx>
- Date: Thu, 14 Sep 2006 13:34:31 -0700
If you are using SQL 2005, you can create a procedure and give RUN AS
permissions.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Dave" <Dave@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:856A3066-B973-4710-94E7-3AE47C11D278@xxxxxxxxxxxxxxxx
I am working on a system where I create an archive file using a modified
sp_create_removable that allows non sysadmin to run it.
The file can be created fine as db_owner but when I attempt to detach
using
sp_detach_db I cannot because I have to be a system administrator to use
that
procedure which calls sp_updatestats and DBCC DETACHDB.
Anybody ever get around this before?
--
Regards,
Dave
.
- Prev by Date: RE: Key Management Utility
- Next by Date: Re: Tools For Scanning Data?
- Previous by thread: Credential error when using SSPI
- Next by thread: Re: sp_detach_db when not using a system administrator role
- Index(es):
Relevant Pages
|
