direct SYSADM authority ？？

[li...@eyou.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 .

[Pierre Saint-Jacques]

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:
1133053227.8...@g14g2000cwa.googlegroups.com...

[Knut Stolze]

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

[li...@eyou.com]

thanks , Knut