Viewing 15 posts - 106 through 120 (of 9,715 total)
Big shop or small shop?
I was just reflecting this morning that the employer I currently work for has both. One small unit that has its own collection of DBAs, about...
April 26, 2024 at 1:52 pm
That did not come up in Google. I just looked at it, and the principal ID for all lines is dbo, not the SQL login in question.
Is "name" in that...
April 19, 2024 at 4:21 pm
And now the non-obsolete version that appears to work as well (possibly better?).
$IPAddys = Import-Csv C:\TEMP\FailedSQLLoginSearch_AllSvrs.csv | Select-Object -Property ServerName, LoginName, HostName -Unique
$results=@()
Foreach ($ips in $IPAddys)
{
...
April 5, 2024 at 3:01 pm
WHOO HOO! Figured it out. Needed to throw a hash table in there...
Thank you, Frederico. Without your code I never would have reached this. Now I'm just fiddling with user-friendly...
April 5, 2024 at 2:45 pm
Frederico, the expressions line you gave me isn't working for me. The information writing to the screen is " is unreachable." as if $n.NAME is null or empty and the...
April 5, 2024 at 2:10 pm
At the moment, configuring extended events is not something I can do. We need to jump through hoops to make changes to production servers and this is a high priority...
April 5, 2024 at 12:05 pm
Yes, I was messing around and forgot to change xlxs to csv.
Oddly, I'm not getting a file created with your posted suggestion. I'm going to noodle around a little more...
April 4, 2024 at 4:30 pm
Sigh. I wish I could take comfort in "Your emergency is not my emergency." Sadly, my job makes other people's emergencies my emergency.
Any powershell gurus around? I'm still in my...
April 4, 2024 at 3:02 pm
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
Viewing 15 posts - 106 through 120 (of 9,715 total)