• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

can i change creator of table in db2 database

 
chain singh
Ranch Hand
Posts: 117
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
who do you log into the database as?
 
chain singh
Ranch Hand
Posts: 117
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic