Viewing 15 posts - 91 through 105 (of 9,695 total)
YAY! WITH EXECUTE AS OWNER solved my issue. No extra permissions required, no impersonation permission granted to the user group. Thank you all so much! I appreciate you.
November 1, 2023 at 5:55 pm
AOR = Area of Responsibility. Think of it like departments or smaller chunks of a business division. I am separating out their jobs from the jobs owned by the DBAs...
November 1, 2023 at 4:03 pm
OKAY. Now the WITH EXECUTE AS <user> / OWNER is the syntax I could not for the life of me find. I might try that.
The security is being implemented across...
November 1, 2023 at 2:49 pm
Another approach would be to sign the stored procedure and create a certificate user in MSDB with appropriate permissions. It can get a bit involved but the following may...
October 31, 2023 at 7:18 pm
One approach I can think of to this is to have the end users insert their job request into a table. Then you have a SQL job that runs...
October 31, 2023 at 7:17 pm
I would think you would want to use "EXEC AS" on the proc itself rather than inside the proc.
Sadly, without giving IMPERSONATE to the users, I cannot let them...
October 31, 2023 at 7:15 pm
Of course, after I posted this, I realized that the user running the proc can't grant impersonate on themselves, so I'm ripping that part of the code out. But I...
October 31, 2023 at 11:58 am
From the "Boy, I feel stupid" department, can someone look at and answer this AG question? Availability Group didn't get secondary DB added? – SQLServerCentral Forums
October 13, 2023 at 12:35 pm
BTW, does anyone know if hardware (ISCSI controllers, CPU, memory) resolves the issues with 2022?
I know. Hardware shouldn't be required to fix bad code... but sometimes poor performance can be...
September 13, 2023 at 12:31 pm
Thanks for the post about SQL 2022, Jeff. I've reached out to my team and mentioned that we need to fix all the problems we're currently having with SQL 2017...
September 13, 2023 at 12:29 pm
It's interesting. A few months ago, I had that very same ACE 32 bit vs 64 bit argument with a few people at my new shop. And someone insisted they...
September 5, 2023 at 6:35 pm
The one I'm looking at has 3 legs and a pink bowtie around its neck. So I must be a little behind you, Phil.
August 31, 2023 at 7:30 pm
Sigh. Nope. We should be managing dirty reads on the statement level - not the session level - because apparently there may be some statements in a stored procedure that...
August 23, 2023 at 4:39 pm
As we're sharing "new job" pains, we're likely going to be are taking responsibility of IT services for our parent company in the month months (years).
Ok... let's...
August 23, 2023 at 4:16 pm
Hey, binary still has legs on it!
@=)
August 23, 2023 at 1:25 pm
Viewing 15 posts - 91 through 105 (of 9,695 total)