Re: Changing package's owner
From: Uri Dimant (urid_at_iscar.co.il)
Date: 11/22/04
- Previous message: Bil: "Changing package's owner"
- In reply to: Bil: "Changing package's owner"
- Next in thread: Bil: "Re: Changing package's owner"
- Reply: Bil: "Re: Changing package's owner"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 22 Nov 2004 16:42:59 +0200
Bil
Try
sp_reassign_dtspackageowner [@name =] 'name',
[@id =] 'id',
[@newloginname =] 'newloginname'
"Bil" <biljanat@nbrm.gov.mk> wrote in message
news:%23BepIEK0EHA.1204@TK2MSFTNGP10.phx.gbl...
> Dear All,
>
> Previosly we were using NT 4.0 domain called Domain_A. Recently we
imployed
> Active Directory and moved all domain accounts to a new domain, Domain_B.
We
> are using SQL Server 2000 database installed on Win 2K box. Programers are
> connecting to SQL Server with trusted connection. When User_A (programer's
> account) created a package, the owner of the package appeared as User_A.
> Now, the new account of the same user is User_B. I changed owner in the
> "owner" field in table "sysdtspackages", from User_A to User_B, so the
owner
> of the same package appears as User_B. Now, the problem is that User_B can
> not save its own package - where owner is User_B, but previously was
User_A.
> Pops up a message that only sysadmins and owners can make changes to the
> package (allthow User_B appears to be an owner).
>
> Did anyone encountered this kind of problem?
>
> Thanks in advance.
> Bil
>
>
- Previous message: Bil: "Changing package's owner"
- In reply to: Bil: "Changing package's owner"
- Next in thread: Bil: "Re: Changing package's owner"
- Reply: Bil: "Re: Changing package's owner"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
