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

create users in db2

P: n/a
i developed an app in V.B. now i am trying to connect to db2, i think
before i must create a user in the database, i made it in the next
way.

in db2 control center
user y groups
add new
i gave it all settings but from my app denies me the acces, i can
acces with a ODBC and the user db2admin but i thing it's not right.
thanks in advance.
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
DB2 uses the OS for user authentication. Add the user to the os.

Larry Edelstein

Omar Vazquez wrote:
i developed an app in V.B. now i am trying to connect to db2, i think
before i must create a user in the database, i made it in the next
way.

in db2 control center
user y groups
add new
i gave it all settings but from my app denies me the acces, i can
acces with a ODBC and the user db2admin but i thing it's not right.
thanks in advance.


Nov 12 '05 #2

P: n/a
DB2 has no concept of a database user and of creating one.
In DB2, users must be created in the OS security access methods/files.
When a connect is issued, DB2 asks the OS to validate the user id and pw.
If godd, then DB2 will take over and use the entries you made in control
center.
So create the user in the OS first.
HTH, Pierre.

Omar Vazquez wrote:
i developed an app in V.B. now i am trying to connect to db2, i think
before i must create a user in the database, i made it in the next
way.

in db2 control center
user y groups
add new
i gave it all settings but from my app denies me the acces, i can
acces with a ODBC and the user db2admin but i thing it's not right.
thanks in advance.


--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
Nov 12 '05 #3

P: n/a
After you've defined the user to the operating system; you'll have to
GRANT access to your tables to the user (or to PUBLIC).

See the "SQL Reference Vol. 2" for details about GRANT. See the
"Administration Guide: Implementation" for information about securing
your database. These manuals are supplied with your DB2 distribution and
are also available on the IBM website.

Philip Sherman
Omar Vazquez wrote:
i developed an app in V.B. now i am trying to connect to db2, i think
before i must create a user in the database, i made it in the next
way.

in db2 control center
user y groups
add new
i gave it all settings but from my app denies me the acces, i can
acces with a ODBC and the user db2admin but i thing it's not right.
thanks in advance.


Nov 12 '05 #4

P: n/a
thank to everybody, i can connect to db2 from my app. i'm cheking now
the permission on db2 thank again.
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.