473,215 Members | 1,262 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

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 2444
<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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Tom Loredo | last post by:
Hi folks- I'm about to move from a Solaris 8/SPARC environment to a Dell running RedHat 9. Are there any issues I need to be aware of in bringing my Python code over (mostly scientific...
28
by: grahamd | last post by:
Who are the appropriate people to report security problems to in respect of a module included with the Python distribution? I don't feel it appropriate to be reporting it on general mailing lists.
2
by: malcolm | last post by:
Hello, We have a robust (.NET 1.1 c# winforms) client-server application that utilizes many typed DataSets, typed DataTables and typed DataRows. Our application is a series of windows and popup...
1
by: g | last post by:
Hi, I'm trying to setup the DB2 client to work with LDAP but as soon as I type the 'db2set' command with no parameters I get this error msg: -sh-2.05b$ db2set DBI1306N The instance profile is...
2
by: DB2 News Group | last post by:
Has anyone run into issues of having db2set run by an instance owner process every 10 seconds. We are performing auditing and it is showing up literally every 10 seconds. I have shut down the...
2
by: Yasaswi Pulavarti | last post by:
Does the utility db2set permanently sent variables in the Registry or will it set values only for current session. Thanks, Yasaswi
1
by: GaryDean | last post by:
We have been developing all of our .net applications on 32 bit windows using 32 bit SQL Server. We are being asked to now deploy to servers running 64bit windows and 64bit SQL Server. Are there...
3
by: eschneider | last post by:
Just some common issues with WS: Using custom objects: When objects change, seems you are always fixing some issue. Update references, which sometimes does not work. Deployment: Weird errors...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

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.