• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to grant privilege on particular column in oracle.

 
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)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic