I am building a database view to give a group restricted access to table data. I'm only including fields to which they are allowed to see (sensitive information).
One of the data points they require comes from a dot.walked field, or a join. I can add that separate table to the view and set up the where clause, but the view fails to work unless I include the initial field from which it is dot.walked. The problem is they don't get permission to see that field.
For instance, I have a reference field called Account, that is referring to my Customer_Accounts table.
In Customer_Accounts there is a field called Currency.
I want to include the Account.Currency value without including Account.
Is this possible at all?
Not including the Account field results in this error. Including it causes the view to work properly.
