db2 user authorization

tempe · #1 (**permalink**) 10-10-10, 04:10

i want to grant new database user with authorization..

i want to give new user with authorization to create new database, create table, insert data, etc.. except only drop/delete

what i know, if i want to grant user to connect or so on to a database,
first i have to connect to the database and grant authorization to the user from there..
how about the database that not yet have been created.. that will be created in future... how can i grant the user authorization

sorry for bad english..
any help will be grateful..
thanks

przytula_guy · #2 (**permalink**) 10-10-10, 16:01

for create db sysctrl/sysadmin is needed
with this authority you also get other authority
see infocenter for details about this

Internet Services

Web Development

Digital Marketing

Consumer Tech