User authorization in DB2
Posted
by Daziplqa
on Stack Overflow
See other posts from Stack Overflow
or by Daziplqa
Published on 2010-04-26T05:50:43Z
Indexed on
2010/04/26
5:53 UTC
Read the original article
Hit count: 201
db2
Hi Folks,
I am using win Vista, and I am trying to backup some Database under DB2.
I am logged in using the Administrator
user, and whenever I try to issue the backup command in the "command line processor", I get the following message:
SQL1092N "ADMINISTRATOR" does not have the authority to perform the requested command. SQLSTATE=00000
BTW, I have created a username/password pair (db2admin) while installing the DB2 server.
So, Will this problem will be get solved if I use the db2admin
user? And how to connect to the server (local server BTW) using the db2admin
user ?
© Stack Overflow or respective owner