473,386 Members | 1,705 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,386 software developers and data experts.

direct SYSADM authority ??

Hello , everyone !
It is appreciated that someone tell me what's the difference between
direct SYSADM authority and indirect SYSADM authority .

I am running a DB2 v8.1 fix9 on a linux server . I can only make a user
get an indirect SYSADM authority . How can a user get a direct SYSADM
authority ?

I have read a lot of information and searched through Google , but
found no clue .

thanks for help .

Nov 27 '05 #1
3 3100
Indirect sysadmin is acquired as being a member of a OS group that is
identified to the instance as being sysadm_group.
Look and/or search for sysadm_group in the db2 Admin. Guide under the DBM
CFG list of parameters.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<li***@eyou.com> a écrit dans le message de news:
11**********************@g14g2000cwa.googlegroups. com...
Hello , everyone !
It is appreciated that someone tell me what's the difference between
direct SYSADM authority and indirect SYSADM authority .

I am running a DB2 v8.1 fix9 on a linux server . I can only make a user
get an indirect SYSADM authority . How can a user get a direct SYSADM
authority ?

I have read a lot of information and searched through Google , but
found no clue .

thanks for help .


Nov 27 '05 #2
li***@eyou.com wrote:
Hello , everyone !
It is appreciated that someone tell me what's the difference between
direct SYSADM authority and indirect SYSADM authority .

I am running a DB2 v8.1 fix9 on a linux server . I can only make a user
get an indirect SYSADM authority . How can a user get a direct SYSADM
authority ?


The authorities (SYSADM, SYSCTL, SYSMAINT) are all managed via groups. And
if you got an authoritiy via a group, then you have it as "indirect"
authority. I am not aware of any way to get "direct" authorities.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 28 '05 #3
thanks , Knut

Dec 3 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Al | last post by:
I've been wondering if java is any good at sysadm work on a routine bases, or am I better off with perl/python, etc? thanks Al
0
by: Joachim Klassen | last post by:
Hi all, i'm currently investigating DB2's security and found the following: Env. DB2 ESE 8.1.6 on AIX 5.2.0.0 If you remove the instance owners userid from the AIX group which is the current...
1
by: Thiru | last post by:
Hi, I want to assign SYSADM privileges to user say XYZ. I know that this privileges can't be assigned directly using grant command. But can be acheived by assigning the privileges to group and...
3
by: Jani Tamminen | last post by:
How do I check whether a user have sysadm privilege on DB2 UDB v8.1 database?
11
by: TheBurgerMan | last post by:
Hi all. I am using W2K3, .NET2 on a machine running AD and Exchange. I started getting the message below last week. I googled the error and not much was returned, but I did find this;...
5
by: Rahul B | last post by:
Hi, I am having the following issues while trying to restrict the current user from creating any objects. Below is the privileges for the user and response when i try to create a table in that...
2
by: Dave | last post by:
I've been given the task at work to create a page for the internet. Great, I've never done that before! So I start building. Looks good...flows good...works great internally on the domain, so I...
0
by: louis | last post by:
Question about security best practice. Several best practices articles recommend removing Builtin/ administrator from the sysadmin group. One side affect is that several third party utilities...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
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$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
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...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.