470,833 Members | 1,722 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,833 developers. It's quick & easy.

DB2SET issues

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
3 2361
<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
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
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.

Similar topics

2 posts views Thread by Tom Loredo | last post: by
28 posts views Thread by grahamd | last post: by
1 post views Thread by g | last post: by
2 posts views Thread by DB2 News Group | last post: by
2 posts views Thread by Yasaswi Pulavarti | last post: by
1 post views Thread by GaryDean | last post: by
3 posts views Thread by eschneider | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.