Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 930
  • Last Modified:

How to connect to IBM DB2 8.2 using user name and password

I'm using Command Editor to create table with the following statement:
CREATE DATABASE test USING CODESET UTF-8 TERRITORY JP;
But it fails
In the result pane of Command Editor, it tell me that:

------------------------------ Commands Entered ------------------------------
CREATE DATABASE test USING CODESET UTF-8 TERRITORY JP;
------------------------------------------------------------------------------
CREATE DATABASE test USING CODESET UTF-8 TERRITORY JP
SQL1092N  "HUNGNV  " does not have the authority to perform the requested
command.

SQL1092N  "HUNGNV                                                                " does not have the authority to perform the requested command.
----------------------------------------------------------------------------------
I do not know how to log in to DB2 Database server with other user/id (except current logged in Windows account) by Command Editor or by Control Center.
DB2 is running in Windows 2003 server Enterprise
DB2 version 8.2
I log in to Windows with domain account "HUNGNV" that has  Administrators priority in my PC.
Thank you!
0
fuzzyvss
Asked:
fuzzyvss
  • 2
1 Solution
 
Kent OlsenData Warehouse Architect / DBACommented:

Hi fuzzy,

Just to make sure, are you trying to create a database or a table?  (You state 'table' but the SQL shows 'database'.)

You'll need the administrator user/password if you want to create a database.  To create a table you simply need the proper authority, but that can only be granted by someone with the authority (and cascading GRANT authority) or the administrator.


Kent

0
 
fuzzyvssAuthor Commented:
Sorry, I mean creating database.
I logged in to Windows by Administrator user(user in a domain, not local account, but in Administrators group), But it told me that I have no authority to perform that request.

Thank Kent for your answer.
0
 
Kent OlsenData Warehouse Architect / DBACommented:

When DB2 was installed, an administrator account was created (db2admin is a popular name).  You should use this account.

Kent
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now