Grant update on specific columns of table problem!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Grant update on specific columns of table problem!

Hybrid View

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    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.



    Oracle DBA (OCP) v8i,v9i

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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).
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width