Oracle This user name

Source: Internet
Author: User

Busy work every day, ah, really busy, today in the work of a small problem, is the oracle of the user name, Oracle does not seem to provide a statement such as rename, so can only directly change the lower view, this is my experimental results

SELECT * from user$ where name= ' TEST '

Set Name= ' Wangpeng '
where user#=62


Commit


Alter system checkpoint;


alter system flush Shared_pool; (Empty the Oracle cache, force to read the disk, after the change, depending on the password is invalid, can only use the following statement to reset the password)


Alter user Wangpeng identified by Wangpeng

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.