Change my own password

Change my own password.

schema:gisq

Users should be able to change their own passwords. The administrator should be able to change other people's passwords.

WARNING

Many of these commands will work and change the password for the user scott. This will prevent you and other users from using SQLZoo - if you do change it please set the password back by visiting the appropriate fix page.

ALTER USER scott WITH PASSWORD 'tiger'

!passwd

ALTER USER scott WITH PASSWORD 'tiger'

ALTER USER scott WITH PASSWORD 'tiger'

ALTER USER scott PASSWORD 'tiger'

password

sp_password @old='tiger', @new='tiger'

set password for scott@localhost=password('tiger')

ALTER IDENT scott USING 'tiger'

sp_password @old='tiger', @new='tiger'

db2 does not do passwords. In Unix the command to change the password is passwd.

From with sqlplus the command is password

WARNING: PLEASE DO NOT CHANGE THE PASSWORD. If you change the password the system will not work. No one will be able to connect to this engine - and you will not be able to change it back!

Users

Create a new user

Read tables from another schema/database

Change the default schema/database.

Find another process and kill it.

Set a timeout.

Change my own password

Who am I?