Home > Database > Oracle > body text

How to delete oracle user?

coldplay.xixi
Release: 2020-07-16 13:53:36
Original
9133 people have browsed it

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;
Copy after login

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!

Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!