Skip to Main Content

Oracle Database Discussions

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 on selected columns

GQJan 31 2009 — edited Feb 1 2009
Dear All,

I want to give grant SELECT to some other user on selected columns of my table, how its possible?

For example I have Table1 with columns col1, col2, col3, col4, col5

I am user ABC and I want to give access of col2 and col4 to another user XYZ of the same database.

What SQL I need to apply?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2009
Added on Jan 31 2009
7 comments
12,699 views