Re: How to query node access from the server

     OK,
     1) do a "show obj" to get a list of internal tables
     2) look for authorization.rules
     Type=02, Name ->Authorization.Rules<-,
       homeAddr=63,  create=0, destroy=0, savePointNum=0,
       info
     ->00000009000000030000000000000003000000063097B73800000000000000000000
     000000000000000000000000000000000000000000000000000000000000<-
     3) do a "show node #" where # is the homeaddress of the
     authorization.rules
     4) output will be like:
     adsm> show node 63
     B-Tree ROOT node: PageAddr=63, Lsn=727331.17.1113,
     ObjName=Authorization.Rules
     LeftSib=-1, RightSib=-1, Continuation=-1
     NumRecs=75, Free=319, NextSlot=187, DirOff=0, PartKeyLen=0
     Level=0, NumCols=9, KeyCols=3, PartCols=0, NodeAttr=80
     MaxCapacity=1004, Capacity=1004, Occupancy=685, LowOccupancy=334
       Record 0 (KeyLen=12, DataLen=24):
         Key:  ->(000000B2)(xxxuserid1xxx)(00000001)<-
         Data: ->(0002)(00000000)(./)(.)(xxxnodenamexxx)(xxxuserid2xxx)<-
       Record 1 ...
       ...

     and I believe that
     1) the xxxuserid1xxx is the user id on the client that issued the "set
     access"
     2) the first (./) is a specific file path for which access is granted
     3) the xxxnodenamexxx is the other system to which the access is
     granted
     4) the xxxuserid2xxx is the userid on the other node to which access
     has been granted

     GOSH ! ! !

     You'all are getting ALL OF MY GOOD SECRETS !

     later,
           Dwight





______________________________ Reply Separator _________________________________
Subject: How to query node access from the server
Author:  sharpn (sharpn AT BASAIX.UK.IBM DOT COM) at unix,mime
Date:    4/19/99 5:56 AM


Does anybody know if it is possible to query from the server to see what

access has been granted to the clients ?

Ideally we need to find out from the servers perspective what clients
have granted access to other clients for data restore operations.

We have tried sql queries but can not get the answer. We are also aware
of the 'query access' command from the client.

Many thanks in advance