Oracle PL/SQL Tutorial/User Privilege/Password

Материал из SQL эксперт
Перейти к: навигация, поиск

Change the password for the current user using the PASSWORD command

   <source lang="sql">

SQL> SQL> SQL> PASSWORD Changing password for SYS Old password: New password: Retype new password: Password unchanged SQL></source>


Changing a User"s Password Using the ALTER USER statement

   <source lang="sql">

SQL> SQL> --CONNECT system/manager SQL> CREATE USER user1 IDENTIFIED BY pass1; User created. SQL> SQL> GRANT CREATE SESSION TO user1; Grant succeeded. SQL> SQL> ALTER USER user1 IDENTIFIED BY pass2; User altered. SQL> SQL> DROP USER user1; User dropped.</source>