Unfortunately, the only reply I see is Phil's latest one.  The one before that was flagged as SPAM.

But Phil is well known on this forum, so I doubt his...

Or this, hopefully I wrote it correctly as I currently don't have access to a SQL Server database to test:

select
  tab.name as 'TableName'
, ca.RowCnt as 'RowCount'
from
sys.tables...

Here is my first suggestion, load the output of the view IMPORT_RUN_EMPLOYEE_ATTRIBUTE_VIEW into a properly indexed temporary table and use that temporary table in the query since that view is...

And when you get that answer, what is the next question?

Now, what have you tried in order to solve your problem?

Also look at the connection settings for the users, there may be difference between the users there.

It looks to me like the problem is on the SQL Server side since all the users you try are using the same credentials on the Oracle side.

I would start...

interesting part is that this only happens when I run that query under SA user.  When execute that query under different name, then everything ok. I decided to firstly...

Gee...

Grant just told you:

So, capturing sp_statement_completed or sql_statement_completed would, in fact, capture the trigger.

Also, let's give some context to the whole thing by hopping in the wack machine and revisit the two threads here on SSC.

https://www.sqlservercentral.com/forums/topic/bankers-rounding

https://www.sqlservercentral.com/forums/topic/round-to-even-aka-bankers-rounding-the-final-function

Also, if you do the research you will also find the banker's round, also called round to even is used in signal processing as well.

There are numerous articles on the...

If you are going to use my name, please make sure you spell correctly.

Okay, I am not going to try to write any code until I have a good understanding of what you are attempting to accomplish.

First you are converting from Oracle to...

I hate to say it, but this looks like a set up for failure. The old joke about how do you eat an elephant comes to mine, one bite at...

Out of curiosity, what have you tried to solve this problem?

I ask because I already see one possible solution.