You can use one of two options when you want to pass security-related information, (such as user name and password), associated with a report over a JDBC connection:
- Choose from the list of predefined environment variables; for example, env::username or env::roles
- Define your own specific environment variables to pass to the connection, (session or global), using the formula function, ENV, inside a hidden parameter. For example,
xaction_parameter_passwordis the parameter defined in an .xaction.
In either case, the available selections appear as drop-down options under JDBC Security Configuration when you click Edit Security in the JDBC Data Source dialog box.