Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: help on db2 udb data access

    I am new for db2 udb .I have problem such as "I want to access database tables?" I have createtab,
    bindadd,connect,implicite schema previleges & userID/password.
    I run the query "select tabname,tabschema from syscat.tables where tabschema not like 'SYS%' order by tabname". But from output i got list of tables & schema I could not able to select data or tables other than mine schema.
    "select tabname,colcount,status from syscat.tables where tabschema not like 'SYS%' order by tabname".
    also tried from syscat.tables,syscat.tabauth,,syscat.colauth.....e tc
    so can anybody help me to access database tables which are other than sysstem tables. or suggest me which previleges i should have to access database tables other than above mentioned? and send me sql query to retrive those tables

    thanks & regards.


  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    You need to have the DBA to explicitly grant the rights to tables not in your personal schema. You need the GRANT command (see SQL reference).
    To read data you need SELECT privilege, for modifying you need UPDATE, privilege, etc).


Posting Permissions

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