Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    98

    Unanswered: privileges needed for user performing SQLLDR

    do i need only INSERT privilege for the user performing SQLLDR function?

    also, just checking that oracle doesn't have a clause that grant access to all tables under a user right??


    TIA

    Mark

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Dear mchih,
    You are right, You can load your data into table with Only INSERT privileges. But You CAN NOT perform TRUNCATE option.


    In Oracle you can not grant access to all tables on a perticular schema at a time. you have to do it individually.

    Thanks,

    Hings.

    =======

    Still Learning...

Posting Permissions

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