Export Data Out without xp_cmdshell access

Hi,
One of the development team is testing sp's that need to exporting out data
as txt files. We do not like to grant execute access to 'xp_cmdshell' due to
any number of things that can be done through this in Operatind system.
How can I accomadate this?
The application is running on a Linux server which does not support bcp as
well.
Thank you for your help..
Execute a stored procedure which calls xp_cmdshell. No need to grant execution right for xp_cmdshell
in this case. Make sure that the procedure you create (in master) is owned by dbo so you don't have
a broken ownership chain.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"bluefish" <bluefish@.discussions.microsoft.com> wrote in message
news:DDA1C262-7F1B-4DDB-9602-4E5DB4473FD6@.microsoft.com...
> Hi,
> One of the development team is testing sp's that need to exporting out data
> as txt files. We do not like to grant execute access to 'xp_cmdshell' due to
> any number of things that can be done through this in Operatind system.
> How can I accomadate this?
> The application is running on a Linux server which does not support bcp as
> well.
> Thank you for your help..

Export Data Out without xp_cmdshell access

Hi,
One of the development team is testing sp's that need to exporting out data
as txt files. We do not like to grant execute access to 'xp_cmdshell' due to
any number of things that can be done through this in Operatind system.
How can I accomadate this?
The application is running on a Linux server which does not support bcp as
well.
Thank you for your help..Execute a stored procedure which calls xp_cmdshell. No need to grant executi
on right for xp_cmdshell
in this case. Make sure that the procedure you create (in master) is owned b
y dbo so you don't have
a broken ownership chain.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"bluefish" <bluefish@.discussions.microsoft.com> wrote in message
news:DDA1C262-7F1B-4DDB-9602-4E5DB4473FD6@.microsoft.com...
> Hi,
> One of the development team is testing sp's that need to exporting out dat
a
> as txt files. We do not like to grant execute access to 'xp_cmdshell' due
to
> any number of things that can be done through this in Operatind system.
> How can I accomadate this?
> The application is running on a Linux server which does not support bcp as
> well.
> Thank you for your help..

Export Data Out without xp_cmdshell access

Hi,
One of the development team is testing sp's that need to exporting out data
as txt files. We do not like to grant execute access to 'xp_cmdshell' due to
any number of things that can be done through this in Operatind system.
How can I accomadate this?
The application is running on a Linux server which does not support bcp as
well.
Thank you for your help..Execute a stored procedure which calls xp_cmdshell. No need to grant execution right for xp_cmdshell
in this case. Make sure that the procedure you create (in master) is owned by dbo so you don't have
a broken ownership chain.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"bluefish" <bluefish@.discussions.microsoft.com> wrote in message
news:DDA1C262-7F1B-4DDB-9602-4E5DB4473FD6@.microsoft.com...
> Hi,
> One of the development team is testing sp's that need to exporting out data
> as txt files. We do not like to grant execute access to 'xp_cmdshell' due to
> any number of things that can be done through this in Operatind system.
> How can I accomadate this?
> The application is running on a Linux server which does not support bcp as
> well.
> Thank you for your help..