Changing password for database

Motivation

Security of confidential data is one of the most important aspect of work with databases in international organisations. It provides protection against unauthorized access and inappriopiate use of essential data. To ensure the safety of data it is important to change password. The need to change password may be caused by many reasons, eg.

• your password was compromised
• organization's security policy requires frequent password changes

Step by step

In order to change password to TOTEM Database you should:

1. Log on to the lxplus: lxplus.cern.ch
2. Log on database using sqlplus tool:
   • -> sqlplus login/password@connection
   • where connection is probably devdb10 and login/password are the credentials to your database
   • another way: -> sqlplus /nolog
   • and then -> connect login/password@connection
3. Use the password command and then type old password and the new one
   • SQL> password
4. Inform in safety way all the users using this database about new password

Help

When you have troubles with databases, especially with changing password you can contact with Physics Databases Service:

• PDBService.PhysicsDatabasesSection

-- JakubSzymanek - 05-Jul-2011