DB2 database access
Posted on 2004-08-10
I am facing a very peculiar type of problem. I logged in with the username db2admin and created a database TEST. I have tables and stored procedures defined in that TEST db.
Now when I loggin with some other user (to whom I have given all the previleges), it says that db2admin.tablename is not accessible.
Why is it happening that db2 by default is attaching the name of the schema/username with the table name or stored procedure name ?
Due to this problem, the database access is purely dependent on db2admin user. Is DB2 user dependent ?