Viewing 15 posts - 1 through 15 (of 15 total)
Sure. In my situation, each user has direct access to the data via SSMS.
Here is my function, I have replaced our actual domain, with the word 'domain' below, but...
February 8, 2018 at 12:22 pm
I was able to find out the answer to this. As I said, I am new to RLS and all the examples that I was seeing where for the most...
February 2, 2018 at 3:01 pm
Thank you. I am afraid that I cannot use the application side for this. Plus MS advertises RLS as easier to do than on the application side. I was looking...
February 2, 2018 at 7:48 am
Thank you all. I appreciate everyone's help and advice.
February 18, 2015 at 4:44 pm
Well, my expectation was that since the package was setup the same way and the service account has the exact same privileges on the default instance and the non-default instance,...
February 17, 2015 at 9:01 am
In response to Igor:
The service account has the exact same privileges. The package take data from one table and moves it into another depending on some criteria. While it...
February 16, 2015 at 7:23 am
Hello,
I am sorry to not responded to the last post, but I have been focusing on implementing the suggestions that have been offered here. I was able to eliminate...
February 10, 2011 at 12:39 pm
I have been busy with everyone's suggestions today.
mister.magoo:
Thank you for pointing out that the non-Winuser was making calls to those tables. I am in a situation where I...
January 26, 2011 at 3:58 pm
Craig,
I am attaching a text file with the proc's code. Please excuse the fact that I am including the whole proc. I thought it might give a better sense of...
January 25, 2011 at 1:59 pm
Leo,
I don't mind going thru the trouble of converting my code to non dynamic SQL, and I hear your concerns. But I don't think my issue is that. I check...
January 25, 2011 at 1:23 pm
Craig,
I am working on getting some code in here, but the shortest proc is 195 lines, so I am not sure how much of it is useful to post here....
January 25, 2011 at 1:03 pm
Craig,
sp_calculations does not make any subcalls. The way I have the proc is that I create the T-SQL on the fly. I try to minimized code maintanence, so, I do...
January 25, 2011 at 11:36 am
To answer GRE about the execution plan first: I had to add additional rights to the non-windows user to allow it have sufficient rights to run the execution plan. Then...
January 25, 2011 at 9:39 am
Do you actually get different results? - No, I get the same results, and actually not that many records back, about 171.
Is it possible that the user ID is being...
January 24, 2011 at 4:29 pm
I am opening a query window in Management Studio under each account and the run the same sp with the same parameters, and get different results.
January 24, 2011 at 4:10 pm
Viewing 15 posts - 1 through 15 (of 15 total)