Re: CLRDBFMBR authority

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

I am not really familiar with audit logs, but I doubt it would list 
CLRDBFMBR if it didn't happen.  However, there is no object by that name 
in any library (user or system) on my 5.4 system.

My guess, at least the first place that I would look, is run WRKOBJ 
OBJ(*ALLUSR/CLRDBFMBR) OBJTYPE(*ALL) and see where the object is.  
Probably an application (package?) library.

If it is an object, that is.  Would a service program subprocedure be 
reported as a "function" by auditing?  That's where I'm at a disadvantage. 

Anyway, once you track down the location and, perhaps, purpose of 
CLRDBFMBR, Bryan, it might help to start clearing up the mystery.

I googled CLRDBFMBR, by the way, and the only hits I got were from this 
thread.

	* Jerry C. Adams
*IBM System i Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
	615.995.7024
fax
	615.995.1201
email
	jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Burns, Bryan wrote:
> I do mean CLRDBFMBR, at least that's what's in the audit message of our exit point program.  An example is shown below.
> >From job . . . . . . . . . . . :   QZDASOINIT                                     
>   User . . . . . . . . . . . . :     QUSER                                        
>   Number . . . . . . . . . . . :     309270                                       
> Time sent  . . . . . . . . . . :   14:57:28.574792                                
> Message . . . . :   Audit Record: User BRYANB executed server *NDB, function      
>   CLRDBFMBR for object BLKPICK                                                   
>   AMFLIBS   *FIRST.                                                               
>  
> Thanks,
> Bryan 
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of DeLong, Eric
> Sent: Monday, August 27, 2007 5:02 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: CLRDBFMBR authority
>
>
> Do you mean CLRPFM?  I'm not familliar with CLRDBFMBR...
>
> Eric
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Burns, Bryan
> Sent: Monday, August 27, 2007 3:15 PM
> To: MIDRANGE-L@xxxxxxxxxxxx
> Subject: CLRDBFMBR authority
>
>
> I know that I need to be the owner or have *ALL authority to a file in order to do a CLRDBFMBR (as when doing a replace member with the Excel Transfer Data to iSeries plug-in), but I thought that  *ALLOBJ special authority in my user profile would work too, but it doesn't.  Why is that?  
>
>
> Bryan Burns
> IBM Certified Specialist - iSeries System Command Operations V5R2 
> M.I.S. Department
> ECHO Power Equipment
> www.echo-usa.com
>
>