I am used to oracle schemas, and I am now working with DB2 on the Mainframe. I have a question about DB2 users. When you use a user to create tables, is it only that user that have access to those tables. For example I am installing some middleware and it hold a repository on DB2. The user that I want to own the tables does not have the privilege to set a setting that the tables need (Dynamic Sections), it needs a sysadmin or admin user to create it. If I use the admin user to create the tables can the user that I want to be associated with those tables still be associated with them somehow.
I am using a jdbc string to create the tables with the Dynamic Sections setting.