Previous Topic: Relational Database Query UtilityNext Topic: hsql Standard Output Example


Access Issues

The standard reports generated from the CA Harvest SCM interface require read access to an object before you can generate a report for it. The hsql utility, alternatively, has access to all information stored in the CA Harvest SCM relational database tables. Therefore, access for hsql is not controlled at the object level. Set permission to execute this command using operating system access control methods.

If a user group named HSQL (case-independent) does not exist, access operates as described in the previous paragraph. If such a user group exists, only the users in that user group can execute hsql with one exception-the Admin user group always has permission to access and run hsql.

If a user group named HSQL exists and a user who does not belong to that group tries to run hsql, the user receives the following error message:

No HSQL execution access. Only user in "HSQL" user group can execute HSQL.