By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,677 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

Setting a default schema for a particular group

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.