Grant update on specific columns of table problem!

[amitstora]

Hi!

Working on Oracle v8i with OS as Win2000/NT.

I am facing this peculiar problem as below:

SQL> CONN MAT/MAT@PVPL
Connected.

SQL> CREATE PUBLIC SYNONYM VENDOR_MASTER FOR MAT.VENDOR_MASTER ;

Synonym created.

SQL> GRANT UPDATE(DIVISION,RANGE,REGISTRATION_NUMBER) ON MAT.VENDOR_MASTER TO "00A21";

Grant succeeded.

SQL> CONN 00A21/00A21@PVPL
Connected.
SQL> UPDATE MAT.VENDOR_MASTER
2 SET ACTIVE_FLAG='N';

2230 rows updated.

SQL> ROLLBACK;

Rollback complete.

The user 00A21 should be allowed to update just 3(Three)
columns i.e., DIVISION,RANGE,REGISTRATION_NUMBER on
VENDOR_MASTER TABLE belonging to schema MAT.

Still the user 00A21 is able to update other columns of VENDOR_MASTER table which should not
be allowed after the said grant!

What could have gone wrong!


Thanks & Regards,

Amit.

[jmodic]

Your user 00A21 must have been granted UPDATE ANY TABLE system privilege (either directly or via role), or he has previously allready been granted UPDATE on MAT.VENDOR_MASTER table (either to complete table or at least to ACTIVE FLAG column).