Home  >  Article  >  Database  >  How to delete oracle user?

How to delete oracle user?

coldplay.xixi
coldplay.xixiOriginal
2020-07-16 13:53:369102browse

How to delete the oracle user: first connect to the Linux system and switch to the oracle installation user; then run the oracle environment variable and enter the oracle console; finally enter the delete command [drop user a casca].

How to delete oracle user?

How to delete the oracle user:

1. Because oracle runs under the Linux system, first, you need to connect Linux system.

How to delete oracle user?

#2. Switch to the oracle installation user. My user is oracle.

How to delete oracle user?

#3. Run the oracle environment variables to enter relevant commands.

How to delete oracle user?

4. Enter the oracle console. Enter the command: sqlplus/as sysdba;

How to delete oracle user?

5. Take deleting temp01 as an example, the command is:

drop user temp01 cascade;

How to delete oracle user?

Related learning recommendations: oracle database learning tutorial

The above is the detailed content of How to delete oracle user?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn