A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
How to grant privilege on particular column in oracle.
Joined: Mar 28, 2012
Jan 16, 2014 08:01:55
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
Joined: Aug 22, 2010
Jan 17, 2014 00:39:00
No, there isn't any other way. You need to create a view and grant select on the entire view. In Oracle,
privilege cannot be granted on individual columns (unlike
I agree. Here's the link:
subject: How to grant privilege on particular column in oracle.
managing users , roles , privileges
How can we Extract from database and assign it to a variable
Any way to avoid changing java.policy?
I want to add button in one column of table
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014