How to modify the oracle username username-CodePudding

As title,
How to use the command to modify the user of oracle user name

CodePudding user response:

Oracle user name can also modify?

CodePudding user response:

Can ah, but I don't know how to modify someone must know the BBS,

CodePudding user response:

Name is a code, can't change, and there is no need to change, if consider security, should is to modify the password, if you have obsessive-compulsive disorder, then you can create a again, and then the data exp, to import the imp

CodePudding user response:

Modify the user name?
Demand is what,,,,
Change the owner?

CodePudding user response:

Login to the identity of the sysdba:
Update user $set name='MY_USER2 where name=' MY_USER1 '; You can modify the user name

CodePudding user response:

Is going to change the username of the user data backup before they are deleted, again the user name according to want to rebuild and then import the original user's data to new users

CodePudding user response:

You can try the following way:
- change the underlying table direct USER $change USER name:
1, run the CMD Windows platform

2, up sqlplus/nolog

3, SQL> Connsys/lmis @ lmisdx_localas sysdba connect to the database, usually can use the sys user login,

4, SQL> Select * from user $; Find the name for the user to modify user#,

5, SQL> UPDATE USER $SET NAME='new USER NAME' WHERE USER#=38;
The updated 1 row,

6, SQL> COMMIT; Submit a completed,

7, SQL> The ALTER SYSTEM CHECKPOINT.
System is changed,

8, SQL> The ALTER USER new username IDENTIFIED BY the new password;
This time you will be prompted new user does not exist,

SQL> The ALTER USER new username IDENTIFIED BY the new password

* ERROR in line 1: the ORA - 01918: users' new users' there is no

9, SQL> The ALTER SYSTEM FLUSH SHARED_POOL;
System is changed,

10, SQL> The ALTER USER new USER IDENTIFIED BY the new password;
The user has changed,

11, test the connection
SQL> CONN new user/password @ lmisdx_local;
The connected,

12, SQL> SELECT * FROM TAB.
Check whether there is the original user under the new user object, such as table,

13, SQL> CONN/AS SYSDBA connected,

14, SQL> SHOW the USER - view the current connection USER
For the "SYS"

15, SQL> SHUTDOWN IMMEDIATE - close the database
Database has been closed, have unloaded database, ORACLE routines have been closed,

16, SQL> STARTUP - start the database
ORACLE routine has been launched,... Database loading is completed, the database has been opened,

17, you can see no recovery for the TEST
SQL> SELECT USER#, the NAME and the PASSWORD FROM the USER $WHERE USER#=38;

18, view the data object
SQL> SELECT * FROM TAB.

19, SQL & gt; Connsys/lmis @ lmisdx_localas sysdba
The connected,
SQL> SHOW USERUSE
For the "SYS"
- it's no problem for me to DROP the USER
SQL> DROP the USER TEST1 CASCADE; - delete the previous user
The user has discarded

CodePudding user response:

refer to 7th floor a275838263 response:

you can try the following way:
- change the underlying table direct USER $change USER name:
1, run the CMD Windows platform

2, up sqlplus/nolog

3, SQL> Connsys/lmis @ lmisdx_localas sysdba connect to the database, usually can use the sys user login,

4, SQL> Select * from user $; Find the name for the user to modify user#,

5, SQL> UPDATE USER $SET NAME='new USER NAME' WHERE USER#=38;
The updated 1 row,

6, SQL> COMMIT; Submit a completed,

7, SQL> The ALTER SYSTEM CHECKPOINT.
System is changed,

8, SQL> The ALTER USER new username IDENTIFIED BY the new password;
This time you will be prompted new user does not exist,

SQL> The ALTER USER new username IDENTIFIED BY the new password

* ERROR in line 1: the ORA - 01918: users' new users' there is no

9, SQL> The ALTER SYSTEM FLUSH SHARED_POOL;
System is changed,

10, SQL> The ALTER USER new USER IDENTIFIED BY the new password;
The user has changed,

11, test the connection
SQL> CONN new user/password @ lmisdx_local;
The connected,

12, SQL> SELECT * FROM TAB.
Check whether there is the original user under the new user object, such as table,

13, SQL> CONN/AS SYSDBA connected,

14, SQL> SHOW the USER - view the current connection USER
For the "SYS"

15, SQL> SHUTDOWN IMMEDIATE - close the database
Database has been closed, have unloaded database, ORACLE routines have been closed,

16, SQL> STARTUP - start the database
ORACLE routine has been launched,... Database loading is completed, the database has been opened,

17, you can see no recovery for the TEST
SQL> SELECT USER#, the NAME and the PASSWORD FROM the USER $WHERE USER#=38;

18, view the data object
SQL> SELECT * FROM TAB.

19, SQL & gt; Connsys/lmis @ lmisdx_localas sysdba
The connected,
SQL> SHOW USERUSE
For the "SYS"
- it's no problem for me to DROP the USER
SQL> DROP the USER TEST1 CASCADE; - delete the previous user
The user has discarded

Hello, I use the dba account login did not find the user $table, modify dba_users table as if also not line, could you tell me do you have any other modification methods

CodePudding user response:

Why do you want to modify the user name, do what is the purpose of?

CodePudding user response:

http://www.cnblogs.com/xujiating/p/6337511.html

CodePudding user response:

Update user $set name='new' where name='old'
Operation, under the system administrator DBA user should be able to achieve, or the user the following table export, delete, and then to build the user, the import table, may be used

CodePudding user response:

1, enter CMD command interface
2, change the password for the administrator user (a) : in the command input interface up sqlplus "/as sysdba" which can be an administrator link is successful,
3, change the password for the administrator user (2) : the SQL command interface input the alter user system identified by 123456; This command will mean the password for the administrator user system is set to 123456
4, modify the average user password: (a) need to be administrator user link success, first in the command input interface up sqlplus "/as sysdba" link to success as an administrator,
5, modify the average user password (2) : the SQL command the alter user interface input username identified by 123456. This command will mean administrator user username (did previously created the username of the user password is set to 123456.
6, can through the database administrator user and normal user link, to open the CMD command in the command input interface up sqlplus and prompts for a user name, and then input to modify a good password password,
5,

CodePudding user response:

 as an administrator login 
nullnullnullnullnullnullnull