fuzzyvss
asked on
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!
CREATE DATABASE test USING CODESET UTF-8 TERRITORY JP;
But it fails
In the result pane of Command Editor, it tell me that:
--------------------------
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!
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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