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

DB2SET issues

P: n/a
Dear all,

On W2K DB2 V8.2.2, is it possible to execute DB2SET command using an
account that is neither a member of LOCAL nor DOMAIN Admin group?

I have created a non-admin domain account to log in the machine and
include it to a group that is assigned to SYSADM_GROUP. It can do all
sort of things except that it returns SQL1092N when executing DB2SET
command.

We run in a Domain Controller environment.

Many thanks!

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
<ne*****@hotmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...
Dear all,

On W2K DB2 V8.2.2, is it possible to execute DB2SET command using an
account that is neither a member of LOCAL nor DOMAIN Admin group?

No. This is not permitted, as you don't have the rights.

I have created a non-admin domain account to log in the machine and
include it to a group that is assigned to SYSADM_GROUP. It can do all
sort of things except that it returns SQL1092N when executing DB2SET
command.

We run in a Domain Controller environment.

Many thanks!

Nov 12 '05 #2

P: n/a
Thanks Mark.

Would this imply that in oder to perform DBA tasks on Windows platform,
the account must have at least local admin rights?
Mark Yudkin wrote:
<ne*****@hotmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...
Dear all,

On W2K DB2 V8.2.2, is it possible to execute DB2SET command using an
account that is neither a member of LOCAL nor DOMAIN Admin group?

No. This is not permitted, as you don't have the rights.

I have created a non-admin domain account to log in the machine and
include it to a group that is assigned to SYSADM_GROUP. It can do all
sort of things except that it returns SQL1092N when executing DB2SET
command.

We run in a Domain Controller environment.

Many thanks!


Nov 12 '05 #3

P: n/a
In order to set entries in the HKLM part of the registry (DB2SET), you need
the rights to be able to do just that. Administrators have these by default,
normal users do not. The security settings can be changed, but this is
normally not very wise.

I do not know how you define the very generic "DBA tasks", and therefore
cannot answer the question. If you mean "install DB2" and such like, then
yes, you'll need administrative rights. I suggest you read up on Windows
security.

<ne*****@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
Thanks Mark.

Would this imply that in oder to perform DBA tasks on Windows platform,
the account must have at least local admin rights?
Mark Yudkin wrote:
<ne*****@hotmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...
> Dear all,
>
> On W2K DB2 V8.2.2, is it possible to execute DB2SET command using an
> account that is neither a member of LOCAL nor DOMAIN Admin group?

No. This is not permitted, as you don't have the rights.
>
> I have created a non-admin domain account to log in the machine and
> include it to a group that is assigned to SYSADM_GROUP. It can do all
> sort of things except that it returns SQL1092N when executing DB2SET
> command.
>
> We run in a Domain Controller environment.
>
> Many thanks!
>

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.