GRANT SELECT on selected columns
GQJan 31 2009 — edited Feb 1 2009Dear All,
I want to give grant SELECT to some other user on selected columns of my table, how its possible?
For example I have Table1 with columns col1, col2, col3, col4, col5
I am user ABC and I want to give access of col2 and col4 to another user XYZ of the same database.
What SQL I need to apply?
Thanks