Shulou(Shulou.com)05/31 Report--

This article introduces you how to modify the database user name in Oracle19c, the content is very detailed, interested friends can refer to, hope to be helpful to you.

1. Stop application

To prevent the application from initiating the wrong connection all the time after changing the user name and password, you can query which IP is connecting to the database in advance, and then disconnect the corresponding connection (here you need to use trigger to record client IP)

Select username,machine,terminal,program,client_info,logon_time from v$session order by logon_time desc

two。 Modify user name

The user information is saved in the table user$, so modify the user name as follows:

Sqlplus / as sysdba show pdbs; alter session set container=SRMPDB; select user#,name from user$;-- SRMPRO-- modify username update user$ set name='SRM' where name='SRMPRO';-- perform forced refresh alter system checkpoint; alter system flush shared_pool;-- change password alter user SRM identified by "XXXXX1234"

3. Restart the application

Restart the application after modifying the database connection configuration.

On how to modify the database user name in Oracle19c to share here, I hope the above content can be of some help to you, you can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.