Professional Web Applications Themes

DB2 Client - IBM DB2

- - - What is needed to give an End User access to some tables with an interactive tool. Why isn't this DB2 Client enough? - - - When I run a DB2 Connect Personal Edition 7.2 - everthing works fine. But this is much more, than an End User ought to see. Then I found this DB2 Client (runtime - dk version). I installed it, and it works as long as I use the db2admin or an Administrator to connect to the db. (I only installed the RunTime, not Administration nor Development.) But I cannot make it work for ...

  1. #1

    Default DB2 Client


    - - -

    What is needed to give an End User access to some tables with an
    interactive tool. Why isn't this DB2 Client enough?

    - - -

    When I run a DB2 Connect Personal Edition 7.2 - everthing works fine.
    But this is much more, than an End User ought to see.


    Then I found this DB2 Client (runtime - dk version). I installed it,
    and it works as long as I use the db2admin or an Administrator to
    connect to the db.

    (I only installed the RunTime, not Administration nor Development.)

    But I cannot make it work for ordinary EndUsers.

    I get an 'SQL0551' - execute permissions.
    If I try to bind using the Client Configuration Assistant. It seems
    that it cannot find what's needed. Connection is okay - but no selects
    can be done.

    I have setup a ODBC DataSource for the database needed..

    I have grantet connect auth to the user(s), and granted select,
    insert, delete, update to them. On the database menu I've tried to
    give them connect and bind.

    (I hate this bind thing.)



    Thans for any help.
    /Jep


    Jep Guest

  2. #2

    Default Re: DB2 Client

    Jep <dk> wrote:
     

    Why do you think it is not enough?
     

    Have a look at authorization and privileges in the docmuntation. The GRANT
    statement is used to allow users to access or execute certain operations.
    It seems that you (as the database administrator) did not give the user in
    question the privilege to perform a SELECT against the table.
     

    Maybe you should statem exactly what you did, how you did the GRANT, how you
    connected to the database and so on.

    --
    Knut Stolze
    Information Integration
    IBM Germany / University of Jena
    Knut Guest

  3. #3

    Default Re: DB2 Client

    On Wed, 15 Oct 2003 13:29:55 +0200, Knut Stolze <ibm.com>
    wrote:
     

    The users have SELECT, INSERT, UPDATE, DELETE rights.

    They have been granted CONNECT and BIND.

    Do you mean that I have to know every build in package to 'GRANT
    EXECUTE' on ex. SQLC2D04, SQLC3D09, etc. ... ???

    - - -

    If the problem is on the DB Server side (Authorisations), why does it
    work, when I install the full DB2 Connect Pers Edition ?? And not when
    I run the simple DB2Client ???

    Auth's were not changed .


    /Jep



    Jep Guest

  4. #4

    Default Re: DB2 Client

    Jep wrote:
     
    >
    >
    > The users have SELECT, INSERT, UPDATE, DELETE rights.
    >
    > They have been granted CONNECT and BIND.
    >
    > Do you mean that I have to know every build in package to 'GRANT
    > EXECUTE' on ex. SQLC2D04, SQLC3D09, etc. ... ???[/ref]

    Jep,

    You need to bind the client code to the database(s) that your users
    will connect to. This is a one time exercise (for a particular
    client fixpack level), and should be done by a user with BINDADD
    authority (i.e. db2admin ).

    In the Configuration Assistant, choose the database, and then choose
    'Selected ... Bind' in the menu. You should select all utilities,
    and in the Bind Options, set "BLOCKING ALL" and "GRANT PUBLIC"

    Then all of your client machines will be able to connect and use
    the database.


    Good luck,





    -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
    http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
    -----== Over 100,000 Newsgroups - 19 Different Servers! =-----
    Ian Guest

Similar Threads

  1. Flash Webcam client <-> client (not client <-> server<-> client)
    By bivald in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: April 24th, 10:33 PM
  2. client-to-client communication via SOAP
    By Bruce in forum ASP.NET Web Services
    Replies: 4
    Last Post: March 28th, 02:31 AM
  3. Adding client-script to handle client events
    By Andrea Williams in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: April 12th, 10:18 PM
  4. Replies: 0
    Last Post: December 11th, 06:12 PM
  5. XP, IBM Access Connections, Cisco VPN client, Novell client
    By Jonathan in forum Windows Networking
    Replies: 0
    Last Post: July 11th, 06:56 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139