Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007
    Posts
    14

    Unanswered: error when i update privilege to a column in a table

    I want to give update privilege to a column in a table. i have given a syntax

    SQL>GRANT UPDATE ON EMP(EMP_NO) TO LEEA;

    ERROR at line 1:
    ORA-00905: missing keyword

    i am getting this error, kindly give suggestions

  2. #2
    Join Date
    Mar 2004
    Location
    Warsaw / Poland
    Posts
    73
    http://download-uk.oracle.com/docs/c...2a.htm#2062195

    It seems that correct syntax will be
    SQL>GRANT UPDATE (EMP_NO) ON EMP TO LEEA;

Posting Permissions

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