Maintenance User Password Status

Use the rs_helpuser stored procedure to display the password status of the maintenance user.

Sample output for rs_helpuser for TOKYO_RS Replication Server:

Users and Privileges Known at Site repl_rs

   Primary Users
   User Name              Permission(s) Name
   ---------------------- ------------------------------
   TOKYO_RS_id_user       no grants
   sa                     sa
   TOKYO_RS_ra            connect source
   TOKYO_RS_rsi           connect source
   repuser                create object
   TOKYO_RSSD_prim        connect source, primary subscr    


   Maintenance Users
   User name              Destination DS.DB     Password Status     
   ---------------------- --------------------- ---------------
   TOKYO_RSSD_maint        TOKYO_DS.TOKYO_RSSD   Initial
   pubs2_maint             TOKYO_DS.pubs2        Hidden
   pubs2_maint             SYDNEY_DS.pubs2sb     Hidden