Some Oracle Administration

1. create user userid identified by passwd;
2. grant resource to userid;
3. grant create session to userid ;

Changing passwords:

alter user userid identified by passwd;

Showing Users

select * from all_users;

Database Administrator Usernames

Two user accounts are automatically created with the database and granted the DBA role. These two user accounts are:

SYS (initial password: CHANGE_ON_INSTALL)
SYSTEM (initial password: MANAGER)

How does one create and drop database users?

	CREATE USER scott 
		IDENTIFIED BY tiger		-- Assign password
		DEFAULT	TABLESACE  tools	-- Assign space for table and index segments
		TEMPORARY TABLESPACE temp;	-- Assign sort space

        DROP USER scott CASCADE;		-- Remove user