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
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).