Command auth.

CHRISTER JOHANSSON

Command auth.
--- Received from D.Z013CJ 08-762 5641 00-01-10 08.19
-> DB2-L(a)RYCI.COM

Hi!

I have an authorization problem that puzzles me.

My id is connected to a RACF group that have sysadm
authorization, but I'm not allowed to do -arc log from
SDSF or the console. If I use Opt 7 DB2 Commands from
DB2I or DSN in a batch it works perfectly.

We are using the extended MCS console.

Can anyone tell me what we have missed.


Regards, Christer Johansson, Sys Prog, Swedish Stat Rail



[login to unmask email]

Re: Command auth.
(in response to CHRISTER JOHANSSON)
Hi,

We had the same problem when we moved to RACF from ACF/2 DB2.

When you run the command under SDSF at our site it actually runs under a
userid of SYSOPR and hence SYSOPR requires the ARCHIVE command access.

Hope this helps.

Adrian Talbot
Database Administration Group
Information Services, Level 10, Tower
Bank of Western Australia
Ph : (08) 9449-6273
Fax : (08) 9449-6133
eMail : [login to unmask email]


---------------------------------------- Message History
----------------------------------------


From: CHRISTER JOHANSSON <[login to unmask email]> on 10/01/2000 15:19

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Adrian Talbot/SDG/SS/BankWest)

Subject: Command auth.




--- Received from D.Z013CJ 08-762 5641 00-01-10 08.19
-> DB2-L(a)RYCI.COM

Hi!

I have an authorization problem that puzzles me.

My id is connected to a RACF group that have sysadm
authorization, but I'm not allowed to do -arc log from
SDSF or the console. If I use Opt 7 DB2 Commands from
DB2I or DSN in a batch it works perfectly.

We are using the extended MCS console.

Can anyone tell me what we have missed.


Regards, Christer Johansson, Sys Prog, Swedish Stat Rail










_______________________________________________________________________________
Unencrypted electronic mail is not secure and may not be authentic.
If you have any doubts as to the contents please telephone to confirm.

This electronic transmission is intended only for those to whom it is
addressed. It may contain information that is confidential, privileged
or exempt from disclosure by law. Any claim to privilege is not waived
or lost by reason of mistaken transmission of this information.
If you are not the intended recipient you must not distribute or copy this
transmission and should please notify the sender. Your costs for doing
this will be reimbursed by the sender.
_______________________________________________________________________________



[login to unmask email]

Re: Command auth.
(in response to Adrian.Talbot@BANKWEST.COM.AU)
Hi,
Maybe you can check SYSIBM.SYSUSERAUTH to see if the grantee SYSOPR has the
ARCHIVEAUTH = Y.
Regards,

The-Thanh LUONG
AGF Belgium Insurance, DB Administration and Security MGR
E-mail <mailto: [login to unmask email]>
URL http://www.agf.be

===== Standard Disclaimer: opinions expressed are strictly my own, etc...
=====



-----Original Message-----
From: CHRISTER JOHANSSON [mailto:[login to unmask email]
Sent: Monday, January 10, 2000 8:19 AM
To: [login to unmask email]
Subject: Command auth.


--- Received from D.Z013CJ 08-762 5641 00-01-10 08.19
-> DB2-L(a)RYCI.COM

Hi!

I have an authorization problem that puzzles me.

My id is connected to a RACF group that have sysadm
authorization, but I'm not allowed to do -arc log from
SDSF or the console. If I use Opt 7 DB2 Commands from
DB2I or DSN in a batch it works perfectly.

We are using the extended MCS console.

Can anyone tell me what we have missed.


Regards, Christer Johansson, Sys Prog, Swedish Stat Rail



http://www.ryci.com/db2-l. The owners of the list can be reached at
[login to unmask email]

begin 600 winmail.dat
M>)\^(AT(`0:0"``$```````!``$``0>0!@`(````Y`0```````#H``$(@`<`
M&````$E032Y-:6-R;[login to unmask email]%I;"Y.;W1E`#$(`06``P`.````T`<!``H`
M"0```!H``0`&`0$@@`,`#@```-`'`0`*``D````;``$`!P$!"8`!`"$````U
M-$4S.#9!-$$T0S9$,S$Q0C=!,#0P,#$S,S`P,#`V.0#/!@$$@`$`$@```%)%
M.B!#;VUM86YD(&%U=&@N`+`%`0V`!``"`````@`"``$#D`8`'`H``#0````#
M`#8```````,``(`((`8``````,````````!&`````%*%``#P$P``'@`!@`@@
M!@``````P````````$8`````5(4```$````$````."XU``L``H`((`8`````
M`,````````!&``````:%`````````P`#@`@@!@``````P````````$8`````
M`84````````+``2`""`&``````#`````````1@`````#A0````````L`!8`(
M(`8``````,````````!&``````Z%`````````P`&@`@@!@``````P```````
M`$8`````$(4````````#``>`""`&``````#`````````1@`````1A0``````
M``,`"(`((`8``````,````````!&`````!B%````````'@`)@`@@!@``````
MP````````$8`````-H4```$````!`````````!X`"H`((`8``````,``````
M``!&`````#>%```!`````0`````````>``N`""`&``````#`````````1@``
M```XA0```0````$`````````"P`,@`L@!@``````P````````$8``````(@`
M```````+``V`"R`&``````#`````````1@`````%B`````````(!"1`!````
M?`0``'@$``"5!@``3%I&=5N(H>L#``H`<F-P9S$R->(R`T-T97@%00$#`??_
M"H`"I`/D!Q,"@`_S`%`$5C\(50>R$24.40,!`@!C:.$*P'-E=#(&``;#$27V
M,P1&$[<P$BP1,PCO"?>V.Q@?#C`U$2(,8&,`4+,+"0%D,S864`NG8P$P,"!(
M:2P*H@J`36$@>6)E('D(8"!C%P.1$]`%D&L&`%E320A"32X?`55315(`0554
M2"!T;R#?%!`>``:0("`>L"`)P`!PAPZP'@`?`4]04B`3X`,$("#205)#2$E6
M0D4?[login to unmask email]=9%*T96<+$7,=51UD5!ZP!BTE(`!P:"!,54\$3D<=9$%'1B!"
M`&5L9VEU;2!)!P"`"'``<&-E+"!$LD(0P&1M"X`$`'0A(%1T:0(@(`!P9`91
M8TD(<71Y!=!'4AUD138M`,`#$3PJ@B`P.B`1)2<N3'4"(&=`82AG9BX=\#X=
M9%52%$P@+6%H`D!P.B^T+W<N$"XL9"1J/2]ROP8``9`I$`L1)]`$`&,+8>4'
M@'(K0&]P*$$"(`0@_0[`<!@@!!`)@"CP&"`@4%,H@`W@=&PIL&TIL&_,=VXG
MP![login to unmask email]",PUR]R)&HD:BTUXD\%$";@_FX'0`70,?$L8"5`->(=9`Y&`V$K
M0"*@4DE35`$?P"!*3TA!3E.Q(;!.(%LJY3A&+CC7E$!$'V!*'V!%71UDMP9@
M`C`K0$T"(#`0>2?`FDH`<'4*P"FP,3`GP(,!T#VP(#@Z,3D0P`Y-),4K,2?@
M,BU,0(!264-)+D-//E5P4W5B:@60/#$(4&W[`X$R,74@T"-U-2T'\`60.&5I
M=C(A`U(GT"Y:(#`Q,T-*+6`P.`@M-S840#4V-#'7+6)%-SVP+400+3U@1'%.
M+CX0'60M8"T^/O0H7&$I/VP=9!TP(21J29\A\4-0*/%!0P6P:7HHI/4QT&\"
M8&4G$"#0**!+L'AU>GI,``0@!X!!FTV]*;!I*2`$`!Y0`B!N0('+,B$@,6$'
M\$%#)I`)P,T(8'!,-$IC<WDV\"@@MQUD2NLGP&)!8"<@)R<07&YO!4`'0!>P
M=T\$9*4@0"T*P&,@%[!G0X-Y.Z5$4R:0!;$@TDZ1<U\&\$T@)R`@L$I`=100
M(/I/!3$W/O)`Q@0@5+@_`;]*0`6Q56`Y4`N`3U%B**!7$]`@D`5`=P6P:P0@
M<-T$D&9`@3+P09M72I$R8?]6\`N`5)`@T@[!"?`!`"D@7$U#!?!6%B1J0TJR
M;O\>($[`("`FP`,@!X!:D$Q2?U.`2E0H,#("09\CR!(@:.<%$"AP$H%*;R5Q
M!!!20NL&L`0@4`[login to unmask email]!4X$$`/<EH"_1!4!2*I$NOV>?:*__:38^P!Z1`'`W
M$!X2!<`G4/YB!/0HPC$@*+($(%6B:E'G)X(#(&KO('8$`%IQ(-+[/P-@\6(*
ML&JQ4%(MN#TP"&-I+@6@;2]D8OT_(&PS\"4A,T($D&QA(+3^;"AA'E,=\1@@
M`-`>L#(Q`P5`/P,M4D515447.(`_5R-U?79`'@!P``$````.````0V]M;6%N
M9"!A=71H+@````(!<0`!````&P````&_6SMO?J2&V!/&I!'3MZ!``3,``&D`
M`3*:```#`"8```````,`+@``````"P`K```````+``(``0```!X`0A`!````
M&@```#PR,#`P,#$Q,#`W,3DN=V9&;$!S:BYS93X````#`-X_KV\``$``.0``
MHBO!0%N_`0,`\3\)!```'@`Q0`$````'````5U1,54Y'```#`!I``````!X`
M,$`!````!P```%=43%5.1P```P`90``````#`/T_Y`0```,`@!#_____`@%'
M``$````G````8SU"13MA/2`[<#U!.VP]2$5203(M,#`P,3$P,#@P,#(V6BTT
M.3,```(!^3\!````/P````````#<IT#(P$(0&K2Y"``K+^&"`0`````````O
M3SU!+T]5/3$P+T-./5)%0TE0245.5%,O0TX]5U1,54Y'```>`/@_`0```!$`
M``!,=6]N9RP@5&AE+51H86YH`````!X`.$`!````!P```%=43%5.1P```@'[
M/P$````_`````````-RG0,C`0A`:M+D(`"LOX8(!`````````"]//4$O3U4]
M,3`O0TX]4D5#25!)14Y44R]#3CU75$Q53D<``!X`^C\!````$0```$QU;VYG
M+"!4:&4M5&AA;F@`````'@`Y0`$````'````5U1,54Y'``!```<P*O[<P$!;
MOP%```@PCD9GP4!;OP$>`#T``0````4```!213H@`````!X`'0X!````#@``
M`$-O;6UA;[login to unmask email]:"X````>`#40`0```#\````\,4)"034T0C1$-SDY1#,Q
M,4(W.#`T,#`Q,S,P,#`P-CDP-S9!0C-`:&5R83(N:6YT97)N86PN86=F+F)E
M/@``"P`I```````+`",```````,`!A!RO1FD`P`'$-H#```#`!`0``````,`
M$1`!````'@`($`$```!E````2$DL34%90D593U5#04Y#2$5#2U-94TE"35-9
M4U5315)!551(5$]3145)1E1(14=204Y4145365-/4%)(05-42$5!4D-(259%
M05542#U94D5'05)$4RQ42$4M5$A!3DA,54].1P`````"`7\``0```#\````\
M,4)"034T0C1$-SDY1#,Q,4(W.#`T,#`Q,S,P,#`P-CDP-S9!0C-`:&5R83(N
4:6YT97)N86PN86=F+F)E/@``0T4=
`
end