Working on Oracle v8i with OS as Win2000/NT.
I am facing this peculiar problem as below:
SQL> CONN MAT/MAT@PVPL
SQL> CREATE PUBLIC SYNONYM VENDOR_MASTER FOR MAT.VENDOR_MASTER ;
SQL> GRANT UPDATE(DIVISION,RANGE,REGISTRATION_NUMBER) ON MAT.VENDOR_MASTER TO "00A21";
SQL> CONN 00A21/00A21@PVPL
SQL> UPDATE MAT.VENDOR_MASTER
2 SET ACTIVE_FLAG='N';
2230 rows updated.
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,
Oracle DBA (OCP) v8i,v9i
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).
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Click Here to Expand Forum to Full Width