skip to main content
Using the driver : Using tnsnames.ora files : Connecting to Oracle instances running in restricted mode
  

Try DataDirect Drivers Now

Connecting to Oracle instances running in restricted mode

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)
)
...