Skip to Main Content

SQL & PL/SQL

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 Privilege on table column

449374Dec 14 2010 — edited Dec 14 2010
Hi,
I think it's not possible to provide column level select privilege in a table.

e.g.- grant select (col1,col2) on table1 to user1;

Can anyone suggest what could be the alternate way to achieve this (apart from creating a view on the table).
This post has been answered by Frank Kulash on Dec 14 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 11 2011
Added on Dec 14 2010
7 comments
1,217 views