|
Any users, except for SYS and SYSTEM, can be dropped from the database as long as the user to be dropped is not actively logged on. The following code drops the user as well as all the user's objects: DROP USER username [CASCADE]; The CASCADE option drops all the objects in the schema before dropping the user and must be specified if the schema being dropped contains any objects. If you need to learn about the users in your database, information can, naturally, be found in the data dictionary. |
|