Is there a way you can set permissions or even a username/password on the stored proc to prevent the code being available?
Only problem I see with that is that the sa (db owner) account will have access to all objects in the database anyway?
Hi,
I have created several stored procedures using (WITH ENCRYPTION) option, which makes the proc unreadable.
I have now found utiliies out there that can decrypt and make stored procs available to anybody.
Is there a work around this?
Document in Full Client works perfectly, ie after refresh I can see and save document with all the reports with data.
In Webi, when refreshing sometimes 4/6 reports are being displayed, sometimes 5/6 etc, and the other reports are there but an empty sheet (blank white screen in pdf)!
So when...
We have access to all types of ways to create DP's except using stored procs. When we select them there are no connections to choose from the list.
Would these need to be created at supervisor level? If not, how would one create them?
Thanks.
When folder or file is local then its no problem.
The only way that I can get a job to be sheduled is if the owner is "win2k3Name\Administrator".
But if the package is referencing folder and files on a remote machine then I get error msg.
I even added the remote machine as a trusted...
When running a scheduled job from sql srv 2000 on win2k3, I get a "path not found" error msg in my Activex script task (I'm using Scripting.FileSystemObject).
Its a UNC path name and everyone has folder access and folder exists.
I even mapped the drive and referenced it that way and...
2 prompts in DPA
No prompts in DPB.
DPB (VBA) just filters out the data in DPA.
But whenever I refresh DPB, I get an error saying -
Run-time error 115 - Error Loading the DataProvider.
Only time it works is the first time I create DPB, after that I get this error msg.
Hi,
Two DP's in my report DPA & DPB.
DPA comes out of the universe.
I built DPB using VBA which extracts part of the data out of DPA, but whenever I refresh DPB I get the following error.
Run-time error 115 - Error Loading the DataProvider.
Meaning it cant load DPA for some reason?
I used...
I'm able to loop over a DP using a VB macro in BusObj.
I want to be able to apply some logic to that DP and insert data into another DP and the report to look at that DP.
If you can't insert data into another DP are you able to edit (i.e. delete rows, update values) while your looping over the...
This is what I done initially (apply filter selecting #EMPTY and counting rows) which gives correct result.
However, I want that value on the summary report as I cannot copy it over i.e. summary report has no null filter.
My DP:
Col1 Col2 ...
GUID Name ...
GUID NULL ...
GUID NULL ...
GUID...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.