Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle PL/SQL: USER - misc queries and commands Jump to:  
Category: >> Oracle PL/SQL >> USER - misc queries and commands Bookmark and Share

<< lastnext >>

Snippet Name: USER - misc queries and commands

Description: Some user related queries and commands.

Also see:
» USER - connection information
» USER - User Information 2
» USER idle time
» USER Information
» USER active connected users
» USER memory use
» USER - Connected Users
» USER - drop user
» USER system authentication
» USER lock account
» USER password expiration
» USER profile
» USER tablespace quota
» USER temp tablespace
» USER tablespace
» USER password
» USERS: view specific user info
» USERS: view currently connected users
» USERS: view all active users
» USERS: Drop users
» USERS: Lock and Unlock accounts
» USERS: Proxy Users
» USERS: Grant tablespace access
» USERS: Alter a user
» USERS: CREATE USER w/ authentication
» USERS: Creating Users
» CREATE USER
» Drop User example
» Create User example
» Create User

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 10th, 2009

Change password.
 
ALTER USER SYS
IDENTIFIED BY "ZZ@#$pwrd";
 
========================
 
VIEW Password Hashes
 
CURRENT Password:
 
SELECT name, password
FROM USER$;
 
 
Previous Passwords (requires Profile verify FUNCTION IS active):
 
SELECT u.name, h.password, h.password_date
FROM USER$ u, user_history$ h
WHERE u.USER# = h.USER#;
 
=========================
 
 
Grant Access TO A Tablespace
 
ALTER USER psoug1
QUOTA 100K ON data1;
 
=========================
 
Revoke Access FROM A Tablespace
 
ALTER USER psoug1
QUOTA 0 ON data1;
 
 
=========================
 
LOCK An Account
 
ALTER USER psoug1 ACCOUNT LOCK;
 
=========================
 
Unlock An Account
 
ALTER USER uwclass  ACCOUNT UNLOCK;
 
=========================
 
Change Password Based ON Hash
 
SELECT  password
FROM USER$
WHERE name = 'MikeH';
 
ALTER USER MikeH IDENTIFIED BY XYZ;
 
SELECT password
FROM USER$
WHERE name = 'MikeH';
 
ALTER USER MikeH IDENTIFIED BY VALUES 'F894844C34402B67';
 
conn MikeH/pwd123
 
 
 


Free
Oracle Magazine
Subscriptions
and Oracle White Papers


SQL University.net courses meet the most demanding needs of the business world for advanced education in a cost-effective manner. SQL University.net courses are available immediately for IT professionals and can be taken without disruption of your workplace schedule or processes.

Compared to traditional travel-based training, SQL University.net saves time and valuable corporate resources, allowing companies to do more with less. That's our mission, and that's what we deliver.

Click here to find out more
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 89 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?