PLSQL often overtime heavy input password, switching environment or user input password, tedious, you just need to some simple configuration from the tedious, open PLSQL - & gt; Tools - & gt; Preferences - & gt; The login history - & gt; Fixed users, according to the username/password @ tnsname format configuration, each one a line, is behind the @ runs the setup_cq_ora_user_clob.sql tnsnames. Ora file for each database configuration information, the name of the configuration information is first place=(... In front of the string,
For example: user name: dbname, the password is: dbpassword
Tnsnames. Ora of configuration information:
Dbtnsname=
(
(ADDRESS_LIST=
(ADDRESS=(TCP) PROTOCOL=(HOST=127.0.0.1) (PORT=(1521)))
)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(SERVICE_NAME=XXX)
)
)
Fixed configuration information of users is as follows:
Dbname/dbpassword @ dbtnsname

CodePudding user response:

Thanks for sharing, it is recommended that the record in a blog post,

CodePudding user response:

Saves the time of the every time lost password

CodePudding user response:

In fact also supports ezconnect, also supports the as sysdba

CodePudding user response:

reference 1st floor selling fruit net reply:

thanks for sharing, advice on her blog,

Uh huh, have time to adjust, mobile phones can only post, thanks,

CodePudding user response:

Enter the password really have a headache, especially in the case mix special characters,

CodePudding user response:

The

reference 3 floor minsic78 response:

actually also supports ezconnect, also supports the as sysdba

Get, thanks,

CodePudding user response:

If your company has a green safe, caught the save the actions of plaintext password, do not know will worry the ceiling

CodePudding user response:

refer to 7th floor minsic78 response:

if your company has a green safe, caught the save the actions of plaintext password, do not know will worry the ceiling

, in accordance with the articles of association, is a knowledge, there is nothing wrong with it, to err is human,

CodePudding user response:

Free to just write their essays just