Meaningless Drivel is fun!*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 222

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
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3606
    
  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.
 
Similar Threads
how can we change width of table column using javascript by mouse dragging
managing users , roles , privileges
Any way to avoid changing java.policy?
How can we Extract from database and assign it to a variable
I want to add button in one column of table