Error while granting select privilege

Posted on

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.

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.

Leave a Reply

Your email address will not be published. Required fields are marked *