How does one create, manage and drop database users?
One can add, drop and manage database users from the Enterprise Manager GUI. The following examples will show how the same can be achieved from the SQL*Plus command prompt: CREATE USER scott IDENTIFIED BY tiger — Assign password DEFAULT TABLESPACE tools — Assign space for table and index segments TEMPORARY TABLESPACE temp; — Assign sort space DROP USER scott CASCADE; — Remove user After creating a new user, assign the required privileges: GRANT CONNECT, RESOURCE TO scott; GRANT DBA TO scott; — Make user a DB Administrator Remember to give the user some space quota on its tablespaces: ALTER USER scott QUOTA UNLIMITED ON tools; Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the DB Configuration Assistant (dbca). DBA’s must unlock these accounts to make them available to users.
