RE: DTS permissions to create
From: Angelina (anonymous_at_discussions.microsoft.com)
Date: 06/23/04
- Next message: betty: "sp3 in sql 2000"
- Previous message: Ganesan Subramanian: "Re: .NET Data Adapter not taking Alias added in ClientNetwork Utility"
- In reply to: Davy: "RE: DTS permissions to create"
- Next in thread: Paul Ibison: "Re: DTS permissions to create"
- Reply: Paul Ibison: "Re: DTS permissions to create"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 22 Jun 2004 23:37:57 -0700
There's no specific stored procedure in msdb that I can
explicity deny that creates the DTS packages?
>-----Original Message-----
>You could try revoking or denying write permissions to
msdb. this is where dts package information is stored I
believe.
>In theory the creation of a package should fail if it
cannot be written to msdb.
>
>"Angelina" wrote:
>
>> How to I revoke the ability of non-sa non-dbo users
from
>> creating DTS packages on a SQL 2000 server?
>>
>> Thx!
>>
>.
>
- Next message: betty: "sp3 in sql 2000"
- Previous message: Ganesan Subramanian: "Re: .NET Data Adapter not taking Alias added in ClientNetwork Utility"
- In reply to: Davy: "RE: DTS permissions to create"
- Next in thread: Paul Ibison: "Re: DTS permissions to create"
- Reply: Paul Ibison: "Re: DTS permissions to create"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
