Learn Oracle

PREVIOUS CHAPTER | NEXT CHAPTER

I have created this learn oracle "The step 10 process" Oracle Tutorial to help Database aspirants to accomplish their dream of working as Oracle Database administrator. I have tried to keep it simple and User friendly. Use NEXT and PREVIOUS Button to navaigate away and to a chapter. Since i myself had been a Database adminstrator trainer and has got real life experience of working as a Oracle DBA, I would welcome any sort of queries and doubts or modifications to webmaster@oracleonline.info.

Step 7 - Dropping users

Learn Oracle - Dropping Users

Enterprise Manager enables Oracle DBA to drop users. However, Oracle DBA must excerise caution when doing so, since dropping user will drop all schema objects owned by the user including tables and indexes. If Oracle DBA want to deny user access to the database, it is better to lock the user account or expire the user password.

To drop a user such as MYUSER:

1. From the Administration page, click Users under the Security heading.

2. Select the MYUSER user, and click Delete. At the confirmation page, click Yes.

PREVIOUS CHAPTER | NEXT CHAPTER

STEP 7 - Next Topics

For users to access your database, Oracle DBA must create user accounts and grant appropriate database access privileges to those accounts. Some user accounts are automatically included in the preconfigured database, but for security reasons, most of these accounts are locked and expired.This Step describes how to create and manage user accounts. Click on Oracle tuorial links below:

Database Administrative Accounts