Connecting to Oracle instances running in restricted mode
- Last Updated: November 30, 2018
- 1 minute read
- DataDirect Connectors
- JDBC
- Oracle Database 6.0
- Documentation
An Oracle instance can run in restricted mode, which allows access only to
users who have the RESTRICTED SESSION system privilege. To connect to an instance running in
restricted mode, add the UR = A clause to the CONNECT_DATA
parameter of the tnsnames.ora file as shown.
...
(CONNECT_DATA=
(SERVICE_NAME = acct.us.yourcompany.com)
(UR = A)
)
...