Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL1092N error creating database

Posted on 2009-12-16
3
Medium Priority
?
1,278 Views
Last Modified: 2012-05-08
Getting following error message
>db2 -v create database reqprodb
create database reqprodb
SQL1092N  "USER" does not have the authority to perform the requested
command.

Where USER domain user and is a user added to the DB2ADMNS and DB2USERS groups locally.
0
Comment
Question by:snorkelfish
3 Comments
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 1000 total points
ID: 26066414
0
 
LVL 37

Expert Comment

by:momi_sabag
ID: 26066439
if it is included in the db2admns group on the local database machine, it should be able to create databases
do you experience this issue with other users as well?
0
 

Accepted Solution

by:
snorkelfish earned 0 total points
ID: 26067164
Adding user to local Administrator group fixed the problem.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question