http://dbaspot.com/forums/db2-udb/203214-sql1092n-user-does-not-have-authority-perform-therequested-command.html
SQL1092N "USER" does not have the authority to perform therequested command - db2-udb
This is a discussion on SQL1092N "USER" does not have the authority to perform therequested command - db2-udb ; Hi all, i have a problem with the authority feature on my machine. It keeps on saying i don't have permission to run "CREATE DATABASE" command in db2cmd. I also having permission issue opening control center. Err : SQL1092N "KONGK" ...
Home > Database Forum > Other Databases > db2-udb > SQL1092N "USER" does not have the authority to perform therequested command
# 1 |
SQL1092N "USER" does not have the authority to perform therequested command Hi all, i have a problem with the authority feature on my machine. It keeps on saying i don't have permission to run "CREATE DATABASE" command in db2cmd. I also having permission issue opening control center. Err : SQL1092N "KONGK" does not have the authority to perform the requested command. The following is "get dbm cfg" output : SYSADM group name (SYSADM_GROUP) = DB2ADMNS SYSCTRL group name (SYSCTRL_GROUP) = SYSMAINT group name (SYSMAINT_GROUP) = I am using domain account login to windows. I have already added domain account kongk into local group DB2ADMNS and it is part of local administrator group. Please help as i cant find any workaround on this. Info : DB2 UDB v8.1 for windows Platform Windows XP Professional Edition Can someone please advice what should i do to workaround this issue ? Thanks in advance. |
# 2 |
Re: SQL1092N "USER" does not have the authority to perform therequested command Hi, |
Database Bot | | Join Date: Sep 2009 Posts: 1,236,248 |
# 3 |
Re: SQL1092N "USER" does not have the authority to perform therequested command hi elza, thanks a lot !!! it works well now. i can create database and open control center now without any problem. |
Database Bot | | Join Date: Sep 2009 Posts: 1,236,248 |
# 4 |
Re: SQL1092N "USER" does not have the authority to perform the requestedcommand d9832834@yahoo.com.au wrote: |
Database Bot | | Join Date: Sep 2009 Posts: 1,236,248 |
# 5 |
Re: SQL1092N "USER" does not have the authority to perform therequested<br> command Hi Ian, thanks for your input. I really appreciate It works well now in my machine. |
Database Bot | | Join Date: Sep 2009 Posts: 1,236,248 |
# 6 |
Re: SQL1092N "USER" does not have the authority to perform therequested<br> command I have tried everything in this article and still have the problem. My environment is: |
Database Bot | | Join Date: Sep 2009 Posts: 1,236,248 |
# 7 |
Re: SQL1092N "USER" does not have the authority to perform therequested command Hi Steve |
Database Newbie | | Join Date: Aug 2010 Posts: 1 |