aspose file tools
The moose likes JDBC and the fly likes can i change creator of table in db2 database Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "can i change creator of table in db2 database" Watch "can i change creator of table in db2 database" New topic
Author

can i change creator of table in db2 database

chain singh
Ranch Hand

Joined: Feb 28, 2012
Posts: 116
hello,

i am using db2 9.7 database .

in my application i create a table using java code, but it makes in db2admin user mode.

i want to make this table in my local user mode in which i am coding.

please help me.

thank you in advance

Chain Singh
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1098

who do you log into the database as?
chain singh
Ranch Hand

Joined: Feb 28, 2012
Posts: 116
on my system i have two user manraj and db2admin.

but i am coding as manraj user

when i create table using command center , it make table by manraj (creater). when i am using that table in my code it will not access.

but when i create table using my java code it will make by db2admin(creater)
and my code accept this table.

all i wanted is , i will make tables in command center and this table is accepted in my java code.

how my code access local users created table which is via command center.
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1098

My exprience of this is with Oracle but I presume that dbs will be the same
this is about how your users are created on the DB. and the access and privilages they are given
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: can i change creator of table in db2 database
 
Similar Threads
java DB2 program
table locks, static connection
Transactional Non-Replicated Database Cache
Fire a trigger from an external application on database update
Access DB2 database from javascript