471,831 Members | 836 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,831 software developers and data experts.

Create Database privilege at an instance for user/group

Hi,

How do I give create database privielege to a specific user/group at a
particular db2 instance ?
I read about various authorities like SYSCTRL etc. but I am interested
in giving only Create database privilege.

I also came across GRANT <system privilege statement and it seems I
can execute following statement to achieve what I want,
GRANT CREATEDBA to <authorization-name>

I have few queries about above statement,
1. Is it possible to have a group-name as authorization-name? and if
yes then does all the users of the group get the createdba privilege
after executing above statement?
2. when I open db2 CLP, and try to execute above statement, a error is
shown that "A database connection does not exist". isn't this privilege
independent of database? why should I connect to database to execute
this statement.
Regards,
Jatinder

Aug 28 '06 #1
1 2610
Jatinder,

Depends on your platform. On LUW you can't do that, CREATE DATABASE
requires a minimum of SYSCTRL, which as you note gives other
privileges, too. CREATEDBA is z/OS specific, as I understand it, and
it's been a long, long time since I worked with that so I can't help
you there.

In DB2 for LUW, you certainly can grant privileges to a group.

/T
ja*************@gmail.com wrote:
Hi,

How do I give create database privielege to a specific user/group at a
particular db2 instance ?
I read about various authorities like SYSCTRL etc. but I am interested
in giving only Create database privilege.

I also came across GRANT <system privilege statement and it seems I
can execute following statement to achieve what I want,
GRANT CREATEDBA to <authorization-name>

I have few queries about above statement,
1. Is it possible to have a group-name as authorization-name? and if
yes then does all the users of the group get the createdba privilege
after executing above statement?
2. when I open db2 CLP, and try to execute above statement, a error is
shown that "A database connection does not exist". isn't this privilege
independent of database? why should I connect to database to execute
this statement.
Regards,
Jatinder
Aug 28 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Shashikant Khandelwak | last post: by
10 posts views Thread by ibm_97 | last post: by
2 posts views Thread by Amber | last post: by
3 posts views Thread by Mark A | last post: by
NeoPa
reply views Thread by NeoPa | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.