Changing package's owner
From: Bil (biljanat_at_nbrm.gov.mk)
Date: 11/22/04
- Next message: Uri Dimant: "Re: Changing package's owner"
- Previous message: Dennis Redfield: "Re: SQL Server - Enterprise Manager"
- Next in thread: Uri Dimant: "Re: Changing package's owner"
- Reply: Uri Dimant: "Re: Changing package's owner"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 22 Nov 2004 15:39:44 +0100
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
- Next message: Uri Dimant: "Re: Changing package's owner"
- Previous message: Dennis Redfield: "Re: SQL Server - Enterprise Manager"
- Next in thread: Uri Dimant: "Re: Changing package's owner"
- Reply: Uri Dimant: "Re: Changing package's owner"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
