Subject Current_User rights
Author Rick Roen
FB 1.5
Delphi 7

I have an employee table that stores US social security numbers and I
want to exclude access from non-administrators on this type of column
(including rate of pay).

I know I can limit access to the table itself and make a view of only
the non-confidential columns, but I wonder if this is the best way?

Could I also just check if the CURRENT_USER has administrative rights
to a table and then just run a different query? If possible, how?