Question :
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.
Answer :
It is possible to grant privileges on specific columns, but you can not do that for SELECT
.
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.