Hi All
I have a question, can you please guys guide me on how to implement it:
We have a set of DB2 installation in different servers.
We need to administer it using our own domain user IDs. For example,
when I login to a DB2 server with my NT domain ID and password, I
should be able to do the DB2 database activities.
My NT domain ID is a power user , not an administrator ID. Our policy
will not allow as to be a Administrator.
I added this domain ID to the DB2 servers DB2ADMIN group, but I cannot
do the database administration..
So can u guys help me on this..
Regards
Santhosh
3  1932 
First, you need to setup a group (name like DB2SUPER) in NT domain.
Second, update your db2 dbm cfg
(SYSADM_GROUP)
(SYSCTRL_GROUP)
(SYSMAINT_GROUP)
(SYSMON_GROUP)
to the group y created
Santhosh wrote: Hi All
I have a question, can you please guys guide me on how to implement it:
We have a set of DB2 installation in different servers.
We need to administer it using our own domain user IDs. For example,
when I login to a DB2 server with my NT domain ID and password, I
should be able to do the DB2 database activities.
My NT domain ID is a power user , not an administrator ID. Our policy
will not allow as to be a Administrator.
I added this domain ID to the DB2 servers DB2ADMIN group, but I cannot
do the database administration..
So can u guys help me on this..
Regards
Santhosh
That will work. By the way, if you are in the SYSADMIN group you have all
the authorities that SYSCONTROL, SYSMAINT, SYSMON would acquire.
Please note, that by not being a local administrator on the platform you wil
still NOT be able to create/drop instances and/or install DB2 or fixpacks.
Those require local administration authority.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<sh*******@gmail.com> a écrit dans le message de news: 11**********************@g10g2000cwb.googlegroups. com... First, you need to setup a group (name like DB2SUPER) in NT domain.
Second, update your db2 dbm cfg
(SYSADM_GROUP)
(SYSCTRL_GROUP)
(SYSMAINT_GROUP)
(SYSMON_GROUP)
to the group y created
Santhosh wrote: Hi All
I have a question, can you please guys guide me on how to implement it:
We have a set of DB2 installation in different servers.
We need to administer it using our own domain user IDs. For example,
when I login to a DB2 server with my NT domain ID and password, I
should be able to do the DB2 database activities.
My NT domain ID is a power user , not an administrator ID. Our policy
will not allow as to be a Administrator.
I added this domain ID to the DB2 servers DB2ADMIN group, but I cannot
do the database administration..
So can u guys help me on this..
Regards
Santhosh
If db2admins is a local Windows group, you must configure DB2 to actually
use it:
db2set -g DB2_GRP_LOOKUP=LOCAL
"Santhosh" <ko******@yahoo.com> wrote in message
news:11**********************@c74g2000cwc.googlegr oups.com... Hi All
I have a question, can you please guys guide me on how to implement it:
We have a set of DB2 installation in different servers.
We need to administer it using our own domain user IDs. For example,
when I login to a DB2 server with my NT domain ID and password, I
should be able to do the DB2 database activities.
My NT domain ID is a power user , not an administrator ID. Our policy
will not allow as to be a Administrator.
I added this domain ID to the DB2 servers DB2ADMIN group, but I cannot
do the database administration..
So can u guys help me on this..
Regards
Santhosh This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Michael Foord |
last post by:
#!/usr/bin/python -u
# 15-09-04
# v1.0.0
# auth_example.py
# A simple script manually demonstrating basic authentication.
# Copyright Michael Foord
# Free to use, modify and relicense.
#...
|
by: Bob Everland |
last post by:
I have an application that is ISAPI and the only way to
secure it is through NT permissions. I need to have a way
to login to windows authentication so that when I get to
the ISAPI application no...
|
by: Billy Jacobs |
last post by:
I have a website which has both secure and non-secure
pages. I want to uses forms authentication. How do I
accomplish this?
Originally I had my web.config file in the root with Forms...
|
by: Tom B |
last post by:
In my web.config file I've specified Windows for the authentication, in IIS
I've set it to Integrated Authentication.
But my SQL connection is still showing Anonymous.
Is there somewhere else I...
|
by: Anonieko Ramos |
last post by:
ASP.NET Forms Authentication Best Practices
Dr. Dobb's Journal February 2004
Protecting user information is critical
By Douglas Reilly
Douglas is the author of Designing Microsoft ASP.NET...
|
by: Andrew |
last post by:
Hey all,
I would like to preface my question by stating I am still learning ASP.net
and while I am confident in the basics and foundation, the more advanced
stuff is still a challenge. Ok....
|
by: Albertas |
last post by:
What I'm doing wrong that I can't make my authentication to work.
Here is the situation: I'm hosting a Web Service from a Windows forms
application, using .NET Framework 3.0 WCF. And I want to...
|
by: troywalker |
last post by:
I am new to LDAP and Directory Services, and I have a project that
requires me to authenticate users against a Sun Java System Directory
Server in order to access the application. I have found...
|
by: Frank Swarbrick |
last post by:
I am trying to understand "client authentication" works. My environment is
DB2/UDB LUW 8.2 on zSeries SLES9 as the database server and DB2 for VSE 7.4
as the client. We currently have DB2/LUW set...
|
by: Rory Becker |
last post by:
Having now created a Custom MembershipProvider that seems to work correctly
with my Logon and ChangePassword controls, I am, as they say, a happy bunny.
The next stange is to move on to the...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |
