Re: problem with orphaned "dbo" user of an attached database
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Fri, 13 Jul 2007 22:12:07 +0000 (UTC)
Holger (Holger@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
thanks for your answer. I know that this is a solution but the problem is
that, for ALTER AUTHORIZATION I need a login and a certificate inside the
master database and also a master key.
I'd like to fairly avoid storing information of any kind inside master -
regardless of what information this is. That's the reason why I was asking
for a solution without a signed stored procdure.
If you prefer you can use impersonation in the procedure, that is EXECUTE
AS.
I'm not sure that I understand your reluctance against storing information
in master. After all, it is here you have information about logins,
databases, server-level permissions, the service master key in master.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Re: problem with orphaned "dbo" user of an attached database
- From: Erland Sommarskog
- Re: problem with orphaned "dbo" user of an attached database
- Prev by Date: Re: Determining permissions through Stored Procedures
- Next by Date: Re: Execute Permission for Database Role
- Previous by thread: Re: problem with orphaned "dbo" user of an attached database
- Next by thread: Re: problem with orphaned "dbo" user of an attached database
- Index(es):
Relevant Pages
|
|
