To add a user, use the CREATE USER command.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
To remove a user, use the DROP USER command.
There is no ARCHIVE USER command. Instead, you'll want to use Oracle's export utility to generate a dump of all objects the user owns. This is done on the database server with the following command:
exp userid=system/manager file=my_user.dmp owner=my_userThe above signs on to the database with the SYSTEM user. The dump file will contain all objects owned by MY_USER.
Dig Deeper on Oracle DBA jobs, training and certification
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.