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:

-- JakubSzymanek - 05-Jul-2011

Edit | Attach | Watch | Print version | History: r4 < r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r4 - 2012-02-02 - LeszekGrzanka
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    TOTEM All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback