在DB2下管理用户 [英] Managing users under DB2

问题描述

我是DB2的新手，我在Oracle上有超过10年的经验。


我实际上订购的书可能有所帮助。直到那时我已经通过IBM的DB2信息中心搜索和阅读，并在IBM的网站上以手册的形式阅读了

。

我正在使用DB2因为客户端使用它，所以就足够了

主题。


我想弄清楚如何更改用户的密码

在控制中心创建。我不喜欢操作系统

身份验证，并且更喜欢所有用户在从任何地方登录时指定用户名和密码

。只要scott知道密码，

用户就可以登录数据库和Tom或Harry，无论是谁b
登录操作系统。


我能够更改实例参数中的设置，以便

数据库本身将在用户尝试使用a / b
登录时对用户进行身份验证用户名和密码。


我使用控制中心创建了一个新用户，带有架构。

很遗憾我无法找到设置密码的方法对于一个新的

用户。


在oracle下设置用户密码非常简单

创建用户或集合使用该命令的用户的密码。

alter user< dbuser>由< dbpassword>标识


有关如何在DB2下完成此任务的任何建议吗？

提前致谢

Gerald

I''m new to DB2, I have over 10 years of experience on Oracle.

I actually have to books on order that might help. Till then I have
been searching and reading through IBM''s DB2 Information Center, as
well as manuals on IBM''s website.
I''m working with DB2 because the client uses it, so enough on that
subject.

I''m trying to figure out how to change the password for a user
created in the control center. I don''t like operating system
authentication, and prefer all users to specify a username and password
when logging in from anywhere. As long a scott knows the password the
user can log onto the databse and Tom or Harry, regardless of who is
logged into the OS.

I was able to change the settings in the instance paramters so that
the database itself will authenticate the user when the user attempts
to signon with a user name and password.

I created a new user using the control center, with a schema.
Unfortunately I unable to find a way to set the password for a new
user.

Under oracle it is very simple to set the user password when
creating the user or set the password for a user using the command.
alter user <dbuser> identified by <dbpassword>

Any suggestions on how to accomplish this under DB2?
Thanks in advance
Gerald

推荐答案

你是如何更改实例参数以便db进行身份验证的？

我的印象是验证的唯一方法是通过操作系统。


拉里E.


杰拉德写道：

How did you change the instance parameters so that the db authenticates?
I was under the impression that only way to authenticate was via the OS.

Larry E.

Gerald wrote:

我''我是DB2的新手，我在Oracle上有超过10年的经验。

我实际上订购的书可能有所帮助。直到那时我已经在IBM的DB2信息中心进行搜索和阅读，以及IBM网站上的手册。
我正在使用DB2，因为客户端使用它，足够的
主题。

我正在试图找出如何更改在控制中心创建的用户的密码。我不喜欢操作系统
身份验证，并且喜欢所有用户在从任何地方登录时指定用户名和密码。只要scott知道密码，
用户就可以登录数据库和Tom或Harry，无论谁登录到操作系统。

我能够更改实例参数中的设置，以便当用户尝试使用用户名和密码登录时，数据库本身将对用户进行身份验证。

我创建了一个新用户使用控制中心，有架构。
不幸的是我无法找到为新用户设置密码的方法。

在oracle下设置用户密码非常简单当
创建用户或使用命令为用户设置密码时。
alter user< dbuser>由< dbpassword>标识

关于如何在DB2下完成此任务的任何建议？

提前谢谢
Gerald

I''m new to DB2, I have over 10 years of experience on Oracle.

I actually have to books on order that might help. Till then I have
been searching and reading through IBM''s DB2 Information Center, as
well as manuals on IBM''s website.
I''m working with DB2 because the client uses it, so enough on that
subject.

I''m trying to figure out how to change the password for a user
created in the control center. I don''t like operating system
authentication, and prefer all users to specify a username and password
when logging in from anywhere. As long a scott knows the password the
user can log onto the databse and Tom or Harry, regardless of who is
logged into the OS.

I was able to change the settings in the instance paramters so that
the database itself will authenticate the user when the user attempts
to signon with a user name and password.

I created a new user using the control center, with a schema.
Unfortunately I unable to find a way to set the password for a new
user.

Under oracle it is very simple to set the user password when
creating the user or set the password for a user using the command.
alter user <dbuser> identified by <dbpassword>

Any suggestions on how to accomplish this under DB2?
Thanks in advance
Gerald

Gerald写道：

我是DB2的新手，我有超过10年的Oracle经验。

我实际上必须订购的书可能有所帮助。直到那时我已经在IBM的DB2信息中心进行搜索和阅读，以及IBM网站上的手册。
我正在使用DB2，因为客户端使用它，足够的
主题。

我正在试图找出如何更改在控制中心创建的用户的密码。我不喜欢操作系统
身份验证，并且喜欢所有用户在从任何地方登录时指定用户名和密码。只要scott知道密码，
用户就可以登录数据库和Tom或Harry，无论是谁登录操作系统。

I''m new to DB2, I have over 10 years of experience on Oracle.

I actually have to books on order that might help. Till then I have
been searching and reading through IBM''s DB2 Information Center, as
well as manuals on IBM''s website.
I''m working with DB2 because the client uses it, so enough on that
subject.

I''m trying to figure out how to change the password for a user
created in the control center. I don''t like operating system
authentication, and prefer all users to specify a username and password
when logging in from anywhere. As long a scott knows the password the
user can log onto the databse and Tom or Harry, regardless of who is
logged into the OS.

用户已定义在控制中心仅代表已获得特权的用户，但与身份验证无关。 DB2

始终**执行操作系统身份验证，但没有什么可以阻止用户使用不同的ID连接到DB2
。从命令行：


scott @ unixhost

Users "defined" in control center only represent users who have been
granted privileges, but have nothing to do with authentication. DB2
always** does OS authentication, but nothing prevents a user from
connecting to DB2 with a different ID. From the command line:

scott@unixhost

db2 connect to sample＃use implicit auth。


数据库连接信息


数据库服务器= DB2 / AIX 8.2.2

SQL授权ID = SCOTT

本地数据库别名=样本

scott @ unixhost

db2 connect to sample # use implicit auth.

Database Connection Information

Database server = DB2/AIX 8.2.2
SQL authorization ID = SCOTT
Local database alias = SAMPLE
scott@unixhost

这篇关于在DB2下管理用户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！