Help - Search - Members - Calendar
Full Version: Change userID
Oracle DBA Forums > Oracle > Oracle Forum
liquid
Hi!

Is there any way to change the name of an Oracle user ID?

Thanks
SteveC
Not directly, but it can be done. Export/import (or datapump) is usually how (fromuser/touser).
liquid
i didn't explain it well. I mean the field USER_ID from DBA_USERS table, because we have made an import/export of a schema from a database to another. But the USER_ID has changed and we have an application that uses this user_id. Any help?

Thanks
SteveC
How can you ensure the user ID is the same from database to database? What a blunder in terms of application design.
Littlewheat
Hi liquid,
u may try change data in table
- update user$ set user#=A where user#=B;

( create user use first free ID)

But (as say Steve) relation to sys.users table is oddish.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.