467,154 Members | 1,225 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,154 developers. It's quick & easy.

Setting a default schema for a particular group

Hi,

We are using DB2 UDB 8.2 on AIX 5.X.

My question is regarding for setting the default schema for a
particular user group. Let explain below.

Let say we are having the following user groups,

DBAS
DEVELOPERS
OTHERS

When DBA users connect to database we want to set the schema
implicitly to abcDBA and DEVELOPERS users connect to database we want
set the scehme implicitly to abcDEV and for OTHERS it should be
abcOTH. How can we achive? Can anyone please help us?

With Regards

Balakrishnan Ethiraju

Jun 20 '07 #1
  • viewed: 1482
Share:
2 Replies
bala_e wrote:
We are using DB2 UDB 8.2 on AIX 5.X.

My question is regarding for setting the default schema for a
particular user group. Let explain below.

Let say we are having the following user groups,

DBAS
DEVELOPERS
OTHERS

When DBA users connect to database we want to set the schema
implicitly to abcDBA and DEVELOPERS users connect to database we want
set the scehme implicitly to abcDEV and for OTHERS it should be
abcOTH. How can we achive? Can anyone please help us?
There is no built in way. You need to build this into the client logic
after connect.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Jun 20 '07 #2
On Jun 20, 9:40 am, Serge Rielau <srie...@ca.ibm.comwrote:
bala_e wrote:
We are using DB2 UDB 8.2 on AIX 5.X.
My question is regarding for setting the default schema for a
particular user group. Let explain below.
Let say we are having the following user groups,
DBAS
DEVELOPERS
OTHERS
When DBA users connect to database we want to set the schema
implicitly to abcDBA and DEVELOPERS users connect to database we want
set the scehme implicitly to abcDEV and for OTHERS it should be
abcOTH. How can we achive? Can anyone please help us?

There is no built in way. You need to build this into the client logic
after connect.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab- Hide quoted text -

- Show quoted text -
Another way but it's tedious. You need to set it in db2cli (client
side).

Jun 20 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Moth | last post: by
1 post views Thread by John L. Clark | last post: by
7 posts views Thread by greatcanyon@yahoo.com | last post: by
1 post views Thread by laredotornado@zipmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.