| 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
|
 |
 |
|
|
subject: can i change creator of table in db2 database
|
|
|