Viewing 15 posts - 1 through 15 (of 230 total)
Thank you, that is most helpful.
I was really hoping for a "magic" work around, and I wanted to be "lazy" and avoid module signing.
HOWEVER, as you said, that really is...
October 5, 2022 at 8:49 pm
Good point I should have been more clear.
The service account has SELECT permissions granted to the views in question.
October 5, 2022 at 4:18 pm
It's a vendor app database so I can't modify the table.
Yeah, I think trigger is where I will have to go.
January 8, 2020 at 11:00 pm
What about storing it in the ring_buffer and just pulling it out of there?
Am I totally missing the purpose of Extended Events? I thought they were supposed to be like...
October 17, 2019 at 4:08 pm
Mostly just talking with other TSQL folks :). We had a friendly water-cooler discussion about how to "best" look at the contents of a table.
Not to get a proper random...
July 12, 2019 at 10:19 pm
Good point, poor clarity on my part.
In this case it executes raw TSQL queries against the server. The client receiving the data is Microsoft SSAS Tabular engine.
It pulls the data...
April 11, 2019 at 4:51 pm
Interesting idea about the deny group.
I checked there is ONE Windows AD group that was set to db_denydatareader.
and THAT WAS IT!~!!! THANKS!!!!!
I ran...
October 2, 2018 at 9:09 am
OK this is more strange:
We took a NEW user, should be the same as the current one...he can query everything just fine... without any issues.
Is there...
October 2, 2018 at 8:22 am
October 2, 2018 at 8:16 am
That schema is owned by the user all called "DB".
What are the impacts if I change the schema DB owner to be dbo as opposed to its current...
October 2, 2018 at 8:01 am
Interesting on the ownership chaining.
The user's default schema is dbo but this table is in the schema called 'DB'
I altered the user to be DB for...
October 1, 2018 at 2:40 pm
SELECT ... FROM...
October 1, 2018 at 2:13 pm
October 1, 2018 at 11:48 am
September 26, 2018 at 10:45 am
Viewing 15 posts - 1 through 15 (of 230 total)