stored procedure xp_cmdshell
From: !!bogus (hello_at_microb.com)
Date: 01/24/05
- Next message: Aaron Weiker: "Re: Getting all items from result set where any item has matching crit"
- Previous message: AFN: "Re: simple ALTER TABLE question"
- Next in thread: Aaron Weiker: "Re: stored procedure xp_cmdshell"
- Reply: Aaron Weiker: "Re: stored procedure xp_cmdshell"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 23 Jan 2005 21:50:25 -0500
Hi,
Here is a small issue. I making an ASP.NET website were users can upload
images. I was originally planning to have the images to SQL, but then
thought that I'd upload them to a regular directory and keep just the name
and location of the file in the sql table. Now, to keep things more
organized, I want to allow each user to have their own directory and they
can create subdirectories inside their folder. I found
master.dbo.xp_cmdshell a good candidate for what I need, but I also found
that I would have to give the user permissions on the xp_cmdshell stored
procedure and of course the master database (which I don't want to do).
How would I fix the problem? I thought that inside my stored procedure, I
can somehow grant the user temporary permission on the master database and
the xp.. stored procedure.
Is there a better solution?
-- Thank you Please post only
- Next message: Aaron Weiker: "Re: Getting all items from result set where any item has matching crit"
- Previous message: AFN: "Re: simple ALTER TABLE question"
- Next in thread: Aaron Weiker: "Re: stored procedure xp_cmdshell"
- Reply: Aaron Weiker: "Re: stored procedure xp_cmdshell"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
