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..
for create db sysctrl/sysadmin is needed
with this authority you also get other authority
see infocenter for details about this
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be