Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: column level grants
You need to determine the list of columns that you need to grant select on.
Create a view tat returns these columns.
Then you can: grant select, update ( col1, col2, etc) on view to your-user.
Regards,
Waleed
-----Original Message-----
Sent: Wednesday, April 24, 2002 10:38 AM
To: Multiple recipients of list ORACLE-L
Yes , thanks.
But , can i grant select on one column and update on another one using views
?
I'm not aware of such a way.
I also almost sure that there is no straight-forward way to do it, but are
there any workarounds for this ?
cheers.
DBAndrey
-----Original Message-----
Sent: Wed, April 24, 2002 3:17 PM
To: LazyDBA.com Discussion
Views are the Way you should Look at....
This will allow you to Give access to Particular Columns.
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 ============================================Live to learn... forget... and learn again.
-----Original Message-----
Sent: Wednesday, April 24, 2002 4:56 PM
To: LazyDBA.com Discussion
Dear gurus !
Is there a way to give column level privileges in 8.1.7 , i.e. i have a
table MYTAB (with more than 2 columns) , owned by AAA. I want to grant user
BBB the following priveleges : select on AAA.MYTAB.COL1
update on AAA.MYTAB.COL2
is it possible at all in 8.1.7?
thanks.
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Apr 24 2002 - 10:33:25 CDT
![]() |
![]() |