cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

Summary: Command line to drop user

Dan_Harlan
1-Newbie

Summary: Command line to drop user

Thanks for all the help. Special thanks to Bob Lehman and Dave DeMay.
I received two solutions and they are:

echo drop user username cascade ; | sqlplus wcadmin/wcadmin@wind

This assumes a password and user of wcadmin and a db name of win -
technically a TNS name of wind. Change appropriatly

If you are running unix add quotes

echo "drop user username cascade ;" | sqlplus wcadmin/wcadmin@wind

and

In that case you need the sqlplus flag to run a sql file from
command line and you place the commands in the sql file. Bada bing.
Oracle website or typing sqlplus will tell you what
command/parameter flag to use.




0 REPLIES 0
Announcements


Top Tags