DB2 Authentication

[serge]

I come from a MS SQL background and I am trying to learn DB2.

I am reading the new book "Understanding DB2".

As i understand now unlike SQL Server where you can configure to use SQL
Authentication or Windows Authentication, DB2 only has OS Authentication?

I am running the DB2 on a Windows 2003 server in a domain.When i create a
new database, the objects are inheriting my username.

What is the best practice? Is it ok that all objects that are being created
in the
database are under my name? Will it be easy to move this database to another
domain and reset the objects to another windows or Unix operating system
account?

Also, if i want others to have "db_owner" rights to the database so that
they don't
connect to the database using my windows user/pass, i am adding the user by
right-clicking
on the database and clicking on Authorities. My concern is I am used to the
"dbo" user in a
SQL server database. Will i have problems if objects get created using
different windows
users? In other words, there is no "dbo" type of user i can use? Will i have
to use a windows
user account to be shared by the database owners in order for all objects to
be owned
by a single user?

Thank you

[Serge Rielau]

serge wrote:

I come from a MS SQL background and I am trying to learn DB2.

I am reading the new book "Understanding DB2".

As i understand now unlike SQL Server where you can configure to use SQL
Authentication or Windows Authentication, DB2 only has OS Authentication?

I am running the DB2 on a Windows 2003 server in a domain.When i create a
new database, the objects are inheriting my username.

What is the best practice? Is it ok that all objects that are being created
in the
database are under my name? Will it be easy to move this database to another
domain and reset the objects to another windows or Unix operating system
account?

Also, if i want others to have "db_owner" rights to the database so that
they don't
connect to the database using my windows user/pass, i am adding the user by
right-clicking
on the database and clicking on Authorities. My concern is I am used to the
"dbo" user in a
SQL server database. Will i have problems if objects get created using
different windows
users? In other words, there is no "dbo" type of user i can use? Will i have
to use a windows
user account to be shared by the database owners in order for all objects to
be owned
by a single user?

In DB2 a "schema" (that would be qualifier of an object) is only very
loosely coupeld to your authorization id.
That is the two registers CURRENT SCHEMA and OWNER just happen to be the
same after you connect.
If you want you can create obejcts like:
CREATE TABLE DBO.T(c1 INT);
or
CREATE FUNCTION MYLIB.FOO() RETURNS INT RETURN 5;

It is entirely up to you how to organize your objects in schemata.
When you do that also look up the concept of PATH which is very much
what you knwo from your favorite OS.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab