Error while granting select privilege

oracle

Can anyone tell what is the wrong with the following statement?

grant select on emp(ename,empno,deptno,job) to C##abc;

It gives error.

Best Answer

It is possible to grant privileges on specific columns, but you can not do that for SELECT.

enter image description here

Restriction on Object Privileges

column

Specify the table or view column on which privileges are to be granted. You can specify columns only when granting the INSERT, REFERENCES, or UPDATE privilege.