|Applies To||RSA Product Set: SecurID|
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.1
|Issue||This article provides information on how to:|
Connect to Authentication Manager 8.1 Database to View or List Database Objects.
1. Create a read-only database user. In the example below, the users ocaadmin and rouser are used only for examples. See the Authentication Manager 8.1 Developer's Guide in the Authentication Manager 8.1 extras.zip, available for download from SecurCare Online, for more details.
2. From the command line, connect to the database as the read-only user. Query the database using a SELECT statement. Note that the statement must be enclosed in single quotes and must end with a semicolon:
Sample output is as follows:
./psql -h localhost -p 7050 -d db -U rouser -o myfilename.csv -c 'SELECT name FROM am_host;'
When done, use \q to exit the pgSQL database command line:
|Notes||Note on the SSL certificate|
When a read-only user account is created, the root CA SSL certificate file (RSAAMTrustedRootSSLCA.crt) is copied into /opt/rsa/am/utils. Transfer this SSL certificate file to the client machine from which you will be accessing the database, using a mechanism such as FTP or SCP for the file transfer. The SSL certificate must be set as a trusted root CA certificate in the client application you will use to connect to the database. See your SQL client utility documentation to set this as a trusted root CA certificate.
|Legacy Article ID||a61308|