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, =ENV("session:xaction_parameter_password") or =ENV("global:xaction_parameter_password") where xaction_parameter_password is 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.