In the Connection window, users cannot use the Tnsnames editor when a user has limited sys rights.
This is not a problem if the user has full Admin rights.
or
User cannot save tnsnames.ora using the Tnsnames editor.
The tnsnames.ora is an Oracle file and not specific to Toad.
Toad for Oracle is a GUI and if it cannot access the tnsnames.ora file, one will be denied to work with the tnsnames.ora file through the Toad Tnsnames editor.
WORKAROUND:
Determine if one can open the tnsnames.ora file as a Admin in Notepad by working around the privilege issue.
RESOLUTION:
Grant privilege to read and write to this file specifically.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center