Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Location
    Jagdishpur
    Posts
    146

    Unanswered: GRANT option Issue for a table

    Hi,
    I am using Oracle9i on SUN OS Solaris-5.8. I would like to give select permission of a table to a <new_user>, but i do not want to give select access of all the columns of the table. How can i do that..?? Is that possible in Oracle?

    The table tab1 is having 10 columns & i want to give access of only 3 columns to <new_user>.

    I am giving this command,

    GRANT SELECT (col1, col2) on tab1 to <new_user>;

    It is giving me error like at Column Name position:

    ERROR at line 1:
    ORA-00969: missing ON keyword

    Could anyone help me please. Thanks in advace.

    Regards,
    - KR

  2. #2
    Join Date
    Apr 2003
    Posts
    6
    You need to create a view (for example) as select col1,col2 ... and grant select on that view.

    Cheers

Posting Permissions

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