Re: Changing package's owner
From: Bil (biljanat_at_nbrm.gov.mk)
Date: 11/23/04
- Previous message: Wen Ou: "RE: help! report users permission on a SQL 2000 server"
- In reply to: Uri Dimant: "Re: Changing package's owner"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 23 Nov 2004 10:57:26 +0100
Uri,
Thank you very much. This resolved my problem. This is undocumented stored
procedure.
Thanks a lot.
Regards,
Bil
"Uri Dimant" <urid@iscar.co.il> wrote in message
news:%23MHRBHK0EHA.3072@TK2MSFTNGP11.phx.gbl...
> 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: Wen Ou: "RE: help! report users permission on a SQL 2000 server"
- In reply to: Uri Dimant: "Re: Changing package's owner"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
