Operating System - HP-UX
1833852 Members
2293 Online
110063 Solutions
New Discussion

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 2
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.