To implement limits on package creation through DTS

#1

Hi Darren

Sorry i confused you with the word user, i should have used DBA,we are 3 of us who can access production database and we login with different id's ,i want to restrict our permissions on production database.we must be able to read the data from production but not delete or write to production through dts

how can i impliment this

Thank
sudh

#2

In message <7756D427-8C17-4CE1-B213-FA820364AB3B (AT) microsoft (DOT) com>, sudha
<anonymous (AT) discussions (DOT) microsoft.com> writes

Quote:

Hi Darren,

Sorry i confused you with the word user, i should have used DBA,we are
3 of us who can access production database and we login with different
id's ,i want to restrict our permissions on production database.we must
be able to read the data from production but not delete or write to
production through dts.

how can i impliment this.

Quote:

Thanks
sudha

Please see the original thread. No need to start a new one.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

To implement limits on package creation through DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

To implement limits on package creation through DTS - 05-12-2004 , 01:31 PM

Re: To implement limits on package creation through DTS - 05-12-2004 , 01:55 PM