db2 user privileges

xquadrat · #1 (**permalink**) 01-12-11, 06:11

Hi,
I'm developing a product installer for an application that has to create a database on a DB2 during installation process. Since the database to be imported is very complex we have to check that the user has DB2 administrative privileges. Is this possible via command line call, or do I need to use a specific API library?

Thanks in advance.

sathyaram_s · #2 (**permalink**) 01-12-11, 12:40

What version of DB2 are you on ? and what platform ?

xquadrat · #3 (**permalink**) 01-13-11, 01:25

db2 9.1 to 9.7 on Windows and Unix

n_i · #4 (**permalink**) 01-13-11, 01:36

I think the simplest way to do it is to rely on DB2 to determine user authorizations: issue the create database command and handle the error if it occurs.

xquadrat · #5 (**permalink**) 01-13-11, 01:44

that's exactly the case we want to avoid with this check ;-)

n_i · #6 (**permalink**) 01-13-11, 05:27

Quote:

Originally Posted by xquadrat

that's exactly the case we want to avoid with this check ;-)

Can you explain why?

The user needs SYSADM or SYSCTRL authority to create a database. How you determine that depends on the DB2 version, operating system, a number of registry variables, security plugin in place, and some instance configuration settings.

Internet Services

Web Development

Digital Marketing

Consumer Tech