aspose file tools*
The moose likes Oracle/OAS and the fly likes How to grant privilege on particular column in oracle. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "How to grant privilege on particular column in oracle." Watch "How to grant privilege on particular column in oracle." New topic
Author

How to grant privilege on particular column in oracle.

Mahtab Alam
Ranch Hand

Joined: Mar 28, 2012
Posts: 281

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.


Oracle Java Programmer , Oracle SQL Expert , Oracle Java Web Component Developer
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

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)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to grant privilege on particular column in oracle.