Connecting to Oracle Instances Running in Restricted Mode
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- 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)
)
...