473,386 Members | 1,924 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

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 1719
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Moth | last post by:
On my first night with schemas, things are not proceeding according to expectations. Given three distinct complexType layouts: <sequence> multiple elements in strict sequence <choice> one...
1
by: John L. Clark | last post by:
I am curious as to the rationale, and effect, of having default namespaces not applying (directly) to attributes (see http://www.w3.org/TR/REC-xml-names/#defaulting). Given an attribute without a...
4
by: Ian | last post by:
I would like to set a path to a schema where both the xml file and the schema are on my local hard drive (e.g. c:\XML\auto.xml and c:\XML\auto.xsd) Thank you, Ian
5
by: Adam Child | last post by:
Hi All, I'm trying to validate an xml document. I'm having trouble setting the default namespace of the xml document. If I hard encode the namespace in the xml file then everything works fine....
7
by: greatcanyon | last post by:
Hi, When I create a new user in DB2, can I set the default schema to an existing schema? The reason I want to do this is that I want to later connect to db2 as this user and access tables...
2
by: Mark | last post by:
Hi... I've been trying the .Validate() method on the XmlDocument to validate some xml against a schema, but one thing I noted was that unless the document explicitly declares the schema as a...
4
by: michael sorens | last post by:
I have successfully bound an XmlDocument to a DataGridView but all fields seem to be strings. I want to retrofit appropriate datatypes on some of the fields. Let me take this in 2 parts. Part...
1
by: laredotornado | last post by:
Hi, I'm using PHP 4.4.4 on Apache 2 on Fedora Core 5. PHP was installed using Apache's apxs and the php library was installed to /usr/local/php. However, when I set my "error_reporting"...
1
by: aj | last post by:
==SQL Server 2005 SP2== Is it possible to set the default schema in code? I know that, for a particular DB user, I can set the default schema statically in Mgmt Studio. However, I want to do...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.