cancel
Showing results for 
Search instead for 
Did you mean: 

Disable update to column.

warghade
Occasional Advisor

Disable update to column.

Hello to all members,

How to disable update, insert or delete to specific column of table.

pl help.


thanx in adv.
2 REPLIES
Wodisch
Honored Contributor

Re: Disable update to column.

hello,

you just have to "revoke" these opject-privileges
from the tables.

HTH,
Wodisch
warghade
Occasional Advisor

Re: Disable update to column.

hi,

if we grant any privilege then it can be revoked.

there is one view dba_updatable_columns with column uptable (yes/no)

so is there any other procedure by which we can restrict user to update perticular column of table.


thanx in adv.