As far as I'm aware, I can't use DTS, since I don't know until execution time how many columns will be returned, nor what their names will be. I'm dynamically constructing ##temp tables, and writting their contents to .XLS files
P
-----Original Message-----
From: Wes Wilson
[mailto:mssqldba-ezmlmshield-x48778904.[Email address protected]
Sent: Friday, May 27, 2005 12:16 PM
To: LazyDBA Discussion
Subject: RE: Permissions
Why not use DTS instead?
But if you want to use sp_OA, how about recreating them in the current
database. SQL will find them in the current dB and not check the Master.
Good luck,
Wes
-----Original Message-----
From: Paul Schlieper
[mailto:mssqldba-ezmlmshield-x34557142.[Email address protected]
Sent: Friday, May 27, 2005 12:11 PM
To: LazyDBA Discussion
Subject: Permissions
Hi all,
I'm trying to have SQL Server write reports to a local drive (OK,
ideally a network drive, but this is not a showstopper).
These were all working fine using xp_cmdshell and BCP. Someone noticed
that this meant that certain users needed access to master, not to
mention xp_cmdshell, and had some security concers. This resulted in my
having to re-do these reports without using xp_cmdshell.
So I tried sp_OA with FileSystemObject to create the files. A wrapper
sproc is calling 17 report sprocs, each of which calls the
report-writting sproc, which contains all the calls to sp_OA.
I have granted execute on the wrapper sproc to Public. But non-admin
users are getting the Execute permission denied error on the sp_OA
sprocs, which are also in master.
So, how can I do this without granting the users (or the reporting NT
group) access to master?
P
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page