SQL> ALTER USER username ACCOUNT LOCK;SQL> ALTER USER username ACCOUNT UNLOCK;To change the password for a user:SQL> alter user username identified by new_password;All at once:
-- Expire, forces to change the password at first loginSQL> alter user username identified by password account lock password expire;
skip to main |
skip to sidebar
ORACLE DEVELOPER
Labels
- connect by prior (1)
- DECODE FUNCTION IN ORACLE (1)
- Difference between database triggers and form triggers? (1)
- Difference between procedure and function. (1)
- Differentiate between TRUNCATE and DELETE. (1)
- Eliminate duplicate rows from table (1)
- Second Largest Number (1)
- What are cursor attributes? (1)
Share
Recent Posts
Blogger Tricks
Blogger Themes
Tags
- connect by prior (1)
- DECODE FUNCTION IN ORACLE (1)
- Difference between database triggers and form triggers? (1)
- Difference between procedure and function. (1)
- Differentiate between TRUNCATE and DELETE. (1)
- Eliminate duplicate rows from table (1)
- Second Largest Number (1)
- What are cursor attributes? (1)
Download
Labels
- connect by prior (1)
- DECODE FUNCTION IN ORACLE (1)
- Difference between database triggers and form triggers? (1)
- Difference between procedure and function. (1)
- Differentiate between TRUNCATE and DELETE. (1)
- Eliminate duplicate rows from table (1)
- Second Largest Number (1)
- What are cursor attributes? (1)
0 comments:
Post a Comment