The SRMtools are a set of tools for Sun Role Manager.
The package contains a collection of useful tools that can aid
during the deployment of a Sun Role Manager deployment.
All the available tools can be used from the combined interface
or using their individual class invocation.
The following is an outline of the feature of each of the tools:

SQLRunner: This tool allows you to run simple SQL queries from
the command line. The wipenulls and movebs functionalities are
implemented using this tool.

BUGenerator: This tool generates a business structure hierarchy
from using either the manager or office location to build the
structure.

SRMsecurity: This tools allows you to encrypt the JDBC service
 user’s password. It encrypts the password and automatically
updates the jdbc.properties file as well. It also allows you to manually encrypt and decrypt the JDBC service password.

rbacxUpdater: This tool allows you to upgrade or build SRM by
providing the zip file containing the external files and/or the
rbacx.war file. It can update an initial rbacx.war file or
customise an existing one. Files to be included for customisation
need to be placed into a directory called ‘resources’.

SRMparser: This sample parser tool illustrates the parsing of two
kind of files, a CVS file as well as a Excel spreadsheet. The
tool also generates the schema file after converting the files
to a SRM compliant CVS file.

Syntax and Usage:
—————-

SRMtools
========

SRMtools -wipenulls

    This will remove all null values from certification

SRMtools -createbs managers

    This will create a business structure according to reporting managers

SRMtools -createbs officename

    This will create a business structure according to office location

SRMtools -movebs business_node

    This will move the business structure from the root one level down to the designated business structure node

SRMtools -passwdenc

    This will encrypt the JDBC service password and update the jdbc.properties file that stores it

SRMtools –encrypt password

    This will simply display the encrypted password

SRMtools –decrypt password

    This will simply display the decrypted password

SRMtools -rbacxupdate rbacx.war srm_home deploy_dest

    This will update the rbacx.war file with appropriate values for first time deployment as well as apply customisations. Simply include all files to be included or modified into a directory called resources.

SRMtools -srmupgrade SRM_external.zip srm_home deploy_dest

    This will extract the SRM_external.zip file which contains SRM files that are not part of the war file and update them appropriately. This can be used to upgrade SRM.

SRMtools –query query

    This will run the SQL query using the connection and access priviledges of the rbacxservice user

SRMtools –query queryfile.sql

    This will run all the SQL queries contained in the file sequentially one by one using the connection and access priviledges of the rbacxservice user

passwd
======

This command is for convennience. It is the same as running
SRMtools -passwdenc

SRMparser
=========

SRMparser filename.csv

SRMparser filename1.xls filename2.xls sheetnumber

Advanced Usage:
————–
In addition to the above interface, each of the tools or modules
also has their own private interfaces that can be called directly.

rbacxUpdater
============

java -cp SRMtools.jar au.com.sun.hdl.tools.rbacxUpdater SRM_external.zip srm_home deploy_dest

    Upgrades installed SRM environment replacing existing files with ones contained in the zip file and also updates the configuration settings.

java -cp SRMtools.jar au.com.sun.hdl.tools.rbacxUpdater rbacx.war srm_home deploy_dest

    Updates the rbacx.war file with configuration settings and also includes customisations that are located in the resources directory

java -cp SRMtools.jar au.com.sun.hdl.tools.rbacxUpdater -unzip filename destination

    Unzip a zip file to a specified directory

java -cp SRMtools.jar au.com.sun.hdl.tools.rbacxUpdater -zip filename directory

    Zip up a directory and place its content into a file

BUGenerator
===========

java -cp SRMtools.jar au.com.sun.hdl.tools.BUGenerator -createbs root_bu root_bu_key manager_role

    Create a new business structure under the specified business structure node optionally with specified role

java -cp SRMtools.jar au.com.sun.hdl.tools.rbacxUpdater -movebs new_root_bu

    Moves existing business structure nodes to specified node

SQLRunner
=========

java -cp SRMtools.jar au.com.sun.hdl.tools.SQLRunner query

    This will run the SQL query using the connection and access priviledges of the rbacxservice user

java -cp SRMtools.jar au.com.sun.hdl.tools.SQLRunner query.sql

    This will run all the SQL queries contained in the file sequentially one by one using the connection and access priviledges of the rbacxservice user

SRMsecurity
===========               

java -cp SRMtools.jar au.com.sun.hdl.tools.SRMsecurity jdbc.properties

    This will encrypt the JDBC service password and update the jdbc.properties file that stores it

java -cp SRMtools.jar au.com.sun.hdl.tools.SRMsecurity –encrypt password

    This will simply display the encrypted password

java -cp SRMtools.jar au.com.sun.hdl.tools.SRMsecurity –decrypt password

    This will simply display the decrypted password

Source/Kaynak : http://blogs.sun.com/handat/entry/sun_role_manager_tools