• Post Reply Bookmark Topic Watch Topic
  • New Topic

How to grant privilege on particular column in oracle.  RSS feed

 
Mahtab Alam
Ranch Hand
Posts: 391
1
Java MySQL Database PHP
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I want to give user select ability on a table but only on one column.
How I can do that .

I don`t want to create a view and then give privileges on that view ,,,is there a way.
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No, there isn't any other way. You need to create a view and grant select on the entire view. In Oracle, SELECT privilege cannot be granted on individual columns (unlike INSERT and UPDATE privileges)
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!