Hello guys,

I would really appreciate if some one could help me on my problem.

I am a beginner user of db2. What I want to do is, lets say a user 'user1' creates a database 'db1' and a table 'mytable' in this database. Now I want another user 'user2' to be able to access and modify 'mytable' created by 'user1'.

What should be the syntax, this is what I am trying.

select * from mytable (this is giving error)

select * from user1.mytable (this works fine)

but I want to use the first command. I do not want to mention the schema name in the above command. Is this possible, if yes what should be the configuration.

I will be really thankful if some one can help me on this.

When you use an unqualified table name in a query (no schema name), DB2 will supply one for you. It defaults, I believe, to the value of CURRENT USER. If you would like it to be different, you can issue "SET CURRENT SCHEMA <schema name>".

Andy

Many thanks Andy. I'm quite clear now. Thanks once again.

Depending on the remote client you are using, you may be able to define the default schema name in your jdbc connection string.

Thanks Marcus_A. Would you mind guiding me. I am using hibernate. What hibernate property should I set for changing schema.

I don't think that would normally be done in Hibernate. It would be done in the DB2 connection string in your application server (jboss, WebSphere, etc.). The default schema name can be defined in a jdbc connection string.