I am using Oracle9i on SUN OS Solaris-5.8. I would like to give select permission of a table to a <new_user>, but i do not want to give select access of all the columns of the table. How can i do that..?? Is that possible in Oracle?
The table tab1 is having 10 columns & i want to give access of only 3 columns to <new_user>.
I am giving this command,
GRANT SELECT (col1, col2) on tab1 to <new_user>;
It is giving me error like at Column Name position: