By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,276 Members | 1,424 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,276 IT Pros & Developers. It's quick & easy.

How to give database creation privelege to a user on Windows?

P: n/a
How to give database creation privelege to a user on Windows?

Regards,
Jatinder

Sep 11 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Found from Google: db2 create databse
From the command reference.

Command Reference

CREATE DATABASE

Initializes a new database with an optional user-defined collating sequence,
creates the three initial table spaces, creates the system tables, and
allocates the recovery log.

This command is not valid on a client.

Scope

In a multi-node environment, this command affects all nodes that are listed
in the db2nodes.cfg file.

The node from which this command is issued becomes the catalog node for the
new database.

Authorization

One of the following:

a.. sysadm
b.. sysctrl
You can see at bottom what groupds the id needs to belong to. Watch out if
you do this and read what suthority you are granting. SYSADMIN is the id
that does/undoes all on an instance and therefore the db's belonging to it.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Jatinder" <ja*************@gmail.coma écrit dans le message de news:
11**********************@b28g2000cwb.googlegroups. com...
How to give database creation privelege to a user on Windows?

Regards,
Jatinder
Sep 11 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.