Grant select to user only to certain columns. Is it possible?.
747152Feb 1 2010 — edited Feb 2 2010Good night:
I'm learning about privileges and roles.
I've tried to limit the select privilege on a table to only some columns of it.
Unfortunately it doesn't work.
GRANT select (employee_id, last_name, job_id)
ON hr.employees
TO Usuario_2;
It comes to an ORA-00969: falta la palabra clave ON (ON key word missing)
Surprisingly it does work with updates.
GRANT update (employee_id, last_name, job_id)
ON hr.employees
TO Usuario_2;
'Sentence processed'.
Could anybody tell me if it's possible to allow the access of users with 'select' only to certain columns not using views?. If its possible. What am I doing wrong?.
Greetings