Results 1 to 3 of 3

Thread: grant statement

  1. #1
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150

    Unanswered: grant statement

    How would you go about granting loadauth to a user?

    DB2 7.2 FP6 on AIX 5.1

    I can't get the syntax I suppose and keeps giving me errors

    any help would be appreciated

    thanks

    Mark

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: grant statement

    can you list the statement you using?

    dollar

    try this statement if it's different than yours:

    GRANT LOAD ON DATABASE TO USER PAUL;

    Originally posted by mark_maz
    How would you go about granting loadauth to a user?

    DB2 7.2 FP6 on AIX 5.1

    I can't get the syntax I suppose and keeps giving me errors

    any help would be appreciated

    thanks

    Mark

  3. #3
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150
    thanks for your help, i was adding the name of the database to the statement ie

    db2 grant load on database databasename to user user1


    your command worked, much appreciated

Posting Permissions

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