Error while granting select privilege


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


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.