Newbe: create users & passwords 
Author Message
 Newbe: create users & passwords
Oracle:

create user joe identified by mypassword;

db2:
?

I have read the SQL reference redbook and I see that DB2 has a create schema
SQL statement.  In the DB2 model is the schema the equivilant of a user in
Oracle? I don't see the password clause in the create schema command if it
is.

Thanks

Joe



Wed, 05 May 2004 21:57:05 GMT
 Newbe: create users & passwords

Am I getting this?

DB2 uses windows authentication for user objects?


Quote:
> Oracle:

> create user joe identified by mypassword;

> db2:
> ?

> I have read the SQL reference redbook and I see that DB2 has a create
schema
> SQL statement.  In the DB2 model is the schema the equivilant of a user in
> Oracle? I don't see the password clause in the create schema command if it
> is.

> Thanks

> Joe



Wed, 05 May 2004 22:43:19 GMT
 Newbe: create users & passwords
DB2 uses the operating system for authenication of the user. DB2 uses
internal capabilities to grant access to DB2 objects for that user.

The operating system authentication can be done by any of the
supported OS platforms.

Lorne

Quote:

> Am I getting this?

> DB2 uses windows authentication for user objects?



> > Oracle:

> > create user joe identified by mypassword;

> > db2:
> > ?

> > I have read the SQL reference redbook and I see that DB2 has a create
> schema
> > SQL statement.  In the DB2 model is the schema the equivilant of a user in
> > Oracle? I don't see the password clause in the create schema command if it
> > is.

> > Thanks

> > Joe

--
Lorne Sunley


Wed, 05 May 2004 23:32:48 GMT
 Newbe: create users & passwords
DB2 uses OS to administer users and groups.
And GRANT and REVOKE SQL Statements to handle rights of those OS users
on DB2 objects

Cheers
Serge
--
Serge Rielau
DB2 UDB SQL Compiler Development
IBM Software Lab, Canada



Thu, 06 May 2004 00:08:33 GMT
 Newbe: create users & passwords
Yes, if you are running Windows on the client and server. If the server is unix,
you can choose client authentication, or server authentication if you trust Unix
security mode. Kerberos is also supported when both client and server are
Windows. Avoid client authentication with Windows 95/98, as their security model
is weak.

Quote:

> Am I getting this?

> DB2 uses windows authentication for user objects?



> > Oracle:

> > create user joe identified by mypassword;

> > db2:
> > ?

> > I have read the SQL reference redbook and I see that DB2 has a create
> schema
> > SQL statement.  In the DB2 model is the schema the equivilant of a user in
> > Oracle? I don't see the password clause in the create schema command if it
> > is.

> > Thanks

> > Joe

--

Certified DB2 Application Developer, DB2 Administrator
For DB2 Service: www.ibm.com/software/data/db2/udb/winos2unix/support
See DB2 tech articles at: www7b.boulder.ibm.com/dmdd/


Thu, 06 May 2004 06:35:45 GMT
 Newbe: create users & passwords
Blair,

we're an e-biz with DB2 V7.1 UDB on AIX 4.3.3. Once a client logs onto our web
server, their requests go through an apps server which then uses a common
'user' to access the database.

Are there any strong reasons to go for SERVER over CLIENT authentication ? It
would appear pointless, but then again I'm new to this platform and
configuration.

TIA

evan p.



Quote:
> Yes, if you are running Windows on the client and server. If the server is unix,
> you can choose client authentication, or server authentication if you trust Unix
> security mode. Kerberos is also supported when both client and server are
> Windows. Avoid client authentication with Windows 95/98, as their security model
> is weak.

--
Posted from  [217.204.143.126]
via Mailgate.ORG Server - http://www.Mailgate.ORG


Mon, 17 May 2004 02:12:06 GMT
 Newbe: create users & passwords
If you authenticate all uers in your app server, then you can use authentication from
the common user.

Quote:

> Blair,

> we're an e-biz with DB2 V7.1 UDB on AIX 4.3.3. Once a client logs onto our web
> server, their requests go through an apps server which then uses a common
> 'user' to access the database.

> Are there any strong reasons to go for SERVER over CLIENT authentication ? It
> would appear pointless, but then again I'm new to this platform and
> configuration.

> TIA

> evan p.



> > Yes, if you are running Windows on the client and server. If the server is unix,
> > you can choose client authentication, or server authentication if you trust Unix
> > security mode. Kerberos is also supported when both client and server are
> > Windows. Avoid client authentication with Windows 95/98, as their security model
> > is weak.

> --
> Posted from  [217.204.143.126]
> via Mailgate.ORG Server - http://www.Mailgate.ORG

--

Certified DB2 Application Developer, DB2 Administrator
For DB2 Service: www.ibm.com/software/data/db2/udb/winos2unix/support
See DB2 tech articles at: www7b.boulder.ibm.com/dmdd/


Fri, 21 May 2004 09:51:50 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. Newbe questions: Setting Passwords

2. Create user and password via SQL script ??

3. creating username and password from user reg data

4. How to create a user with password

5. How to create a user with password]

6. create user / password

7. FW: create user / password

8. How do I create Users and Passwords?

9. Creating New User in Accessdb (with password)?

10. R: Creating New User in Accessdb (with password)?

11. SQL 7.0 Users, Logins & Passwords


 
Powered by phpBB® Forum Software