469,267 Members | 1,108 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,267 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
2 1554
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 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.