Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Grant select to user only to certain columns. Is it possible?.

747152Feb 1 2010 — edited Feb 2 2010
Good 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
This post has been answered by AndyPol on Feb 1 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2010
Added on Feb 1 2010
2 comments
8,888 views