Authorities/privilege required to run get dbm cfg

[jaya]

Hi,

I want to create user who can run just below commands.
attach to instance
get database manager configuration;
connect to database
get database configuration for <db>;
select syscat.dbauth;

Which authorities or privileges should I assign to this user?

[Blair Kenneth Adamache]

You can research this here under the reference tab, specifically SQL for
CONNECT and SELECT, and CLP commands for the others:

http://publib.boulder.ibm.com/infocenter/db2luw/v9/advanced/tocView.jsp?toc=/com.ibm.db2.udb.doc/reference.xml

For example for ATTACH:

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/r0002010.htm

Post by jaya
Hi,
I want to create user who can run just below commands.
attach to instance
get database manager configuration;
connect to database
get database configuration for <db>;
select syscat.dbauth;
Which authorities or privileges should I assign to this user?

[jaya]

Thanks for the reply.
I went through the links, you mentioned. But couldn't find the authorities required to run that command.

[elza]

Which OS you are using?

If its in Unix create an OS user and assign this user to the instance owner's primary group. Then this user will get the same authority of the instance owner.

[jaya]

I am using Unix, but i don't want to assign all Authorities of Instance owner to any other system user.

Is there any other way to do it?