[RastogiKamesh]

Hi,
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:

ERROR at line 1:
ORA-00969: missing ON keyword

Could anyone help me please. Thanks in advace.

Regards,

[aarroyob]

You need to create a view (for example) as select col1,col2 ... and grant select on that view.

Cheers