akapitula · October 4, 2016 13:39
diff --git a/remove_connected_user_oracle_RDS b/remove_connected_user_oracle_RDS
 # In any database editor run SQL: 
 SELECT SID, SERIAL#, STATUS
 FROM V$SESSION
 WHERE USERNAME = '<SCHEME>';

 # then in SQLPlus:  
 exec rdsadmin.rdsadmin_util.kill(SID, SERIAL#);

 # drop it:
 drop user <username> cascade;
	# In any database editor run SQL:
	SELECT SID, SERIAL#, STATUS
	FROM V$SESSION
	WHERE USERNAME = '<SCHEME>';

	# then in SQLPlus:
	exec rdsadmin.rdsadmin_util.kill(SID, SERIAL#);

	# drop it:
	drop user <username> cascade;